Forum Discussion
KellenK
May 26, 2021Copper Contributor
Microsoft Excel 16.49 with macro not responding on Mac Big Sur 11.3
Hello, I am having issues with a specific excel document with macro lagging, not responding and not being able to be saved to my mac running on Big Sur 11.3. I have checked that excel has been updat...
mathetes
May 26, 2021Gold Contributor
I don't know for sure that this is the cause, but just checked my own Mac and Excel status. In each case, you seem to be one iteration behind.
Excel is version 16.50 and Mac Big Sur is 11.4
KellenK
May 27, 2021Copper Contributor
Hi mathetes ,
Thank you. I updated both excel and my Mac to the current updates but I am still having the same issues will the excel document that is running macros.
- mathetesMay 27, 2021Gold ContributorI"m generally not a fan of macros, do all I can to create spreadsheets that rely solely on built-in functions. It's not a total boycott, but pretty darn close.
That said, if this is happening with all your macros on the Mac (or even with most) and you know the same spreadsheet is working on a Windows system, you might try posting a question on the Apple support pages that are comparable to these. If it's only happening with this one spreadsheet, with this one macro, then I'd be curious what's distinctive about this spreadsheet and/or this macro.- KellenKMay 27, 2021Copper ContributorIm not sure I completely understand macros, but I have opened several other documents that also contain macros no problem so Im leaning towards that it is an issue with this one specific document. I tried to 'save as' to see if I could figure out the issue but the document lags so much it wont even let me save, it just goes none responsive.
- mathetesMay 27, 2021Gold ContributorIs it not, then, one you wrote? It's possible, I suppose, that it contains some loop that takes a long time to work through all of its conditions. Could you ask one of your Windows owning colleagues to print it out, the macro that is, to study?