I am using Excel 2016 on Mac. I have created an Excel Add-in, which is using shortcuts to call macros using VBA call. But after updating my Excel to 16.9 (from 15.41) these shortcuts are not working anymore. Can someone give me some idea on how to set the shortcut with ALT key in Excel 2016.
Hi Ward, As far as I know the only way you can refresh PivotTable by shortcut is to run a macro. Sub Macro1 ' ' Macro1 Macro ' ' ActiveSheet.PivotTables('PivotTable1').PivotCache.Refresh End Sub I recorded a macro and created a shortcut key for this macro. When I use Ctrl+Shift+R, I can refresh PivotTable automatically. Hope it's helpful.
Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Hi WardWulf, Could you use other shortcut keys in Excel? For example COPY(Ctrl+C) or PASTE(Ctrl+V).
Then you can open the file in safe mode and check if these shortcut keys work fine. Press Win + R, type ' excel /safe' in the blank box, press Enter.
If it works fine in safe mode, please check the add-ins in your excel and disable them. You also need to check if you have any macros in your Excel. Go to Developer Tab select Macros and check the list in pop-up dialog box.
![Shortcut Shortcut](/uploads/1/2/5/4/125499113/486807810.png)
Any updates and results please let me know. Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful.
![Excel Excel](/uploads/1/2/5/4/125499113/859523942.png)
If you have feedback for TechNet Support, contact. Office 365 64 bit user on Windows 10 and same problem but with Word and Excel (all I use). I used to use shift + F7 for thesaurus in Word and magically quit working. I looked in customize keyboard shortcuts and it is correctly assigned. F4 in Word and Excel is supposed to repeat last action, or it used to, and that quit working as well. Started in safe mode and same issue. Reinstalled Office 365 (didn't uninstall first though) and still the same problem.
Extremely frustrating and time consuming on my part. I'm sure Microsoft is too busy with flashy new features to worry about some basic productivity issue like this. Somewhat unrelated but along the same lines of basic functionality: why does highlighting text in Word deselect it but any other formatting change doesn't? Oddly inconsistent.