Excel 2013 "Calculation is incomplete. Recalculate before saving?"

Anonymous
2014-01-02T22:52:06+00:00

I have a dual-boot laptop and desktop, each w/Office 2010 on Windows 7 and Office 2013 in Windows 8.1 .

On both computers, in Excel 2013 [win 8.1], when I make any changes to a file dialog box with "Calculation ..." as outlined in the title of this msg appears.

If I click Yes, the box just reappears with every click.

If I click No, nothing happens and the file is not saved.

Nothing else can be done, and I need to exit the file without saving.

This occurs *after* making numerous changes to sophisticated files, so has become a major problem.

The workaround on both computers -- use the same files in Office 2010 in Windows 7, and the issue does not occur. Ever.

Currently Office 2013 is not usable due to this issue.

Please advise as to the problem, and especially the solution.

Thank you,

- Mik

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

43 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2017-08-01T04:05:35+00:00

    Thanks, I turned off recalculate before saving and it works

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-08-04T14:36:11+00:00

    No, it just happened again and the fix didn't work this time.

    But I did something else that fixed it.  I removed some conditional formatting rules that were based on a custom function.  These rules weren't really working anyways.  When I scrolled around the formatting would sometimes turn on and sometimes turn off.  This conditional formatting was working in previous versions of office.

    The way I figure these things out is by saving it to a temporary file and deleting different sheets until it saved.  Then I removed different columns until it saved.  So I can find out which bits are causing the problem.

    I tried the other fix and it did not work for me. This fix did. It appears the calculation issue stems from the conditional formatting. That's unfortunate.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-11-17T17:42:03+00:00

    Bizarre solution, but I toggled Design Mode on, hit Save, and it worked!

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2015-10-13T19:17:15+00:00

    Exact same problem, and was preventing me from using my existing sheet. 

    • Also has .xlsm homebrew macros and many conditional formatting cells.
    • Conditions do not reference macros directly, but reference cells which contain macros formula.
    • As previously mentioned, setting CALC to MANUAL (not on save) is a work-around.  Having it on auto-calculate while using the sheet would routinely also crash the entire workbook, so now I must leave auto-calculate set to MANUAL.

    Not super cool.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2015-05-13T13:53:07+00:00

    Hi,

    Any news about the bug fixing? Has Microsoft released a fix for this issue?

    Thanks

    Carlo

    Was this answer helpful?

    0 comments