none
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

    Wednesday, December 12, 2012 10:53 AM

Answers

  • 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

    • Edited by EdwinKuster Wednesday, December 12, 2012 1:34 PM Found solution
    • Marked as answer by EdwinKuster Wednesday, December 12, 2012 1:35 PM
    Wednesday, December 12, 2012 1:23 PM

All replies

  • Check that Excel is using Automatic Calculation mode.

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

    Wednesday, December 12, 2012 12:38 PM
  • 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

    • Edited by EdwinKuster Wednesday, December 12, 2012 1:34 PM Found solution
    • Marked as answer by EdwinKuster Wednesday, December 12, 2012 1:35 PM
    Wednesday, December 12, 2012 1:23 PM