Forum Discussion
Solved
Excel macro not working after Windows update - Office 365
After a recent windows update, a previous Excel vba script that was working, no longer functions correctly. The macro operation, when working, opens a csv file that is defined in the active workbook...
Issue resolved after lots of searching on stackoverflow.
It seems that between Excel V1902 and V2002 a hidden variable _xlfn.SINGLE exists in the workbook. When the macro loops through, it sees the named range, cannot resolve its address or sheet location and stops. The hidden variable was only possible to see after running an additional macro to display hidden named ranges.
The fix was to include a loop to skip the named variable _xlfn* if found. Full detail and solution available on https://stackoverflow.com/questions/65947254/excel-macro-not-working-after-windows-update-office-365/65985711#65985711
We just had a Windows Office 365 update yesterday 7/5/2022, and since then a number of my macros corrupt Excel,, where the sheet tabs disappear, or don't work, and no cell or row or column appears to be selectable, etc, only a close and reopen of the workbook corrects it.
I played around with a simple macro, and found the "Application.Screenupdating = False" is the cause, just commenting it out makes the macro work OK.
I played around with a simple macro, and found the "Application.Screenupdating = False" is the cause, just commenting it out makes the macro work OK.
- Thanks worked for me..
