Excel for Mac installation deletes formulas while opening

[MarcelD73]

Hi,

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,

Marcel

[#2]

Interesting,

the problem has resolved spontaneously....

Best wishes,

Marcel

[#3]

Crazy,

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,

Marcel