Excel for Mac installation deletes formulas while opening

New Contributor



I currently observe an odd behaviour with an Excel for Mac installation (version 16.54):


When I try to open certain xlsx files, I get the warning that some problems with the file were detected. After "repairing", Word opens with a warning window that some user-defined XML elements are not supported by Word. The Word document itself then tells me that formulas were deleted.


I  tracked down which formulas were problematic: In one file a DATEDIF calculation, in the other file a long, but simple formula for radioactive decay correction. Both have worked flawlessly for years, and until a few days ago at least, also on this computer.


Funnily, when I open the same file on a different computer with the same software release of Excel for Mac (16.54), I cannot replicate the problem.


I would be grateful for helpful suggestions!


Best wishes,



2 Replies

the problem has resolved spontaneously....

Best wishes,


and now it has reappeared, not only on Excel for Mac installations, but also on Windows installations, and also with a different Excel file: Now, it was not willing to accept my conditional formatting rules.

This instability is really worrying, so I would be grateful for any helpful suggestions....

Best wishes,