Incomplete calculation. Recalculate before save? Help

Question

I am using Excel 2013 and get mentioned problem every time when I save my document

The document was previously saved under Excel 2010, now it comes up with this message every time I want to save and answering with yes does only cause this same message to come up again and again. So I can only save without recalculate.

Is there any one who can help?

Edwin

Answer 1

Check that Excel is using Automatic Calculation mode.

---

Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/

Answer 2

I have checked an it is using automatic calculation mode

Just found the solution.

I was talking about an xlsm file with a macro attached.

When I signed the file it never came up with the message again. When I removed the signature, the message returned again.

So it had to do with security.

Thanks for the reply