File with macro in excel MAC causing error EXC_BAD_ACCESS

Rafael Jardim Barros 0 Reputation points
2023-06-06T11:57:01.31+00:00

Good morning!

When trying to open a file with macro (.xlsm) on Mac it gives me EXC_BAD_ACCESS error (log summarized below, the full one exceeds amount of characters), this same file worked until yesterday normally.

I believe the problem has to do with some mismatch of the macro that is running (it is a simple macro that does calculation according to the color of the cell):

User's image

What I've tried to do:

1 - Uninstall and reinstall excel;

2 - The file opens normally in the Numbers app and LibreOffice;

3 - When trying to open the file in Windows also gave error;

4 - The app has full permission to access the files and folders of the MAC;

5 - I tried the solutions of the links: Solution 1, Solution 2;

6 - When installing the beta version of Excel, the file opened, but when closing it did not open again and presented the same error.

Imagem

Here is the full Log.pdf.

Kind Regards,

Rafael Jardim Barros

Microsoft 365 and Office Development Other
Microsoft 365 and Office Install, redeem, activate For business MacOS
Microsoft 365 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Excel For business Windows
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.