cannot activate office 2016 for mac freezes

CANNOT ACTIVATE OFFICE 2016 FOR MAC FREEZES UPDATE
CANNOT ACTIVATE OFFICE 2016 FOR MAC FREEZES CODE

Now you should be able to open it without crashing (since obviously the initial compile run on startup prevents the crash somehow).įor others using the file (e.g.

CANNOT ACTIVATE OFFICE 2016 FOR MAC FREEZES CODE

prevents it from beeing saved accidentially with compiled code causing the crash on next open again.

may be only useful if updates are infrequent.optional: write protect file on file-level.(=> the code, although only changed on comment-level, will be internally marked as uncompiled and will be recompiled on next open with enabled macros).if already existing: just change anything there, e.g.

CANNOT ACTIVATE OFFICE 2016 FOR MAC FREEZES UPDATE

Write or update some only-existing comment line inside, e.g.

open foo2.xlsm and do not enable macros.

foo.xlsm to foo2.xlsm (untrusted name/file) Our final 6 to 8 step solution is quite simple since it seems to be a bug with the runtime on compiled macro code workbooks that have been saved and opened anew: as if it slowly internally crashes before it will disappear automatically (also from task manager) (sometimes without the immediate auto-restart dialog). When one debugs/inspects the variables, strange things happen (other objects shown than expected, visual sections of excel elements get completely white/broken). Our problem occurs at definite, always reproducible code locations. So it must be some pretty bad compiled-code processing bug. (see solution below if you don't care about this :) )įor us it happened in code that compiles and runs successful in Excel 2010, 20. I experienced today that this can also resolve 'Can't find project or library' crashes where no reference is actually missing and Excel crashes before you can even get to the reference dialog in the first place.

Close Excel, re-open the previously crashing workbook, and Enable Macros.

Revert any changes you made to Macro Security in steps 3-5.

Save the VB project again and then save the Excel workbook.

In the VB Editor, save the project and then click Debug > Compile VBAProject.

Do not click 'Enable Macros' - instead go to the Developer Tab and.

Go to Trusted Documents and check the “Disable all Trusted Documents” box.

Go to the Trusted Locations tab on the left and check the “Disable all Trusted Locations” box at the bottom.

Click the bullet option entitled “Disable all macros with notification”.

Go to the Developer Tab and click “Macro Security” in the Code section of the Ribbon.

Open a new Excel workbook, not your crashing workbook.

To fix it, use the following steps (all credit to alulla at Ozgrid, whose directions I've lightly adapted for clarity):

This is caused by a macro with a compile error.

Cannot activate office 2016 for mac freezes