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...
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.
mathetes
May 27, 2021Gold Contributor
I"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.
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?