Ctrl+Alt+F5 - is it worth to change/add another shortcut?

MVP

I never used this one

RefreshAllShortcut.JPG

now tried - doesn't work. Okay, checked support https://support.office.com/en-us/article/Excel-keyboard-shortcuts-and-function-keys-for-Windows-1798... - no sign of Refresh All shortcut.

Asked Google - appears what that's quite old issue. For example http://stackoverflow.com/questions/29149366/default-excel-keyboard-shortcut-ctrl-alt-f5-no-longer-wo.... Ctrl+Alt+F5 is reserved by Intel Graphics, even if it doesn't use it:

IGshortcuts.JPG

Internet has a lot of discussions how to disable Intel Graphics shortcut and return back default Excel behavior. Yes, that's a not a big deal, but you have to know about this.

 

These days quite many people have Intel Graphics on their PC:s and i guess 99% of them never use Intel Graphics shortcuts. On the other hand with wider usage of G&T with Excel you have to instruct end users how to refresh data in case of changes (if you try to avoid ActiveWorkbook.RefreshAll() macro and in addition to Refresh connection on opening the file).

 

Yes, Alt+A+R+A exists, but old style Ctrl+something by default will be more suitable.

 

 

 

 

2 Replies

Hi,

 

Perhaps a good idea to suggest this at excel.uservoice.com, Microsoft actively monitors that site for product improvement suggestions.

Hi Jan,

 

You are right, thank you for reminding me that. Will do some later, if no such idea has been submitted.