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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2014-10-07T16:42:28+00:00

    I'm venting: 2013 is hinky imo.  It goes down for almost an entire weekend(?).  I'm done complaining.

    If anyone is looking for a solution in 2013, I used the following formula to conditional format, and it appears to solve the issue for me.  It doesn't work in 2010, but if you need it for 2013, try it:

    =IF((LEFT(FORMULATEXT(SomeCell),1)="="), True, False)

    What a pain and waste of time.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-10-23T20:45:27+00:00

    I have also been annoyed by this problem.  I am using conditional formatting that utilize custom VBA functions.  Never had an issue with Excel 2010, but Excel 2013 is flaky and works unreliably.

    I can provide an xlsm file if that would help someone at MS confirm this problem.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-10-24T05:13:52+00:00

    Hi Rod,

    I am certainly interested in this demo file.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-10-24T16:43:01+00:00

    Hi Rod,

    I am certainly interested in this demo file.

    Ok, can you email me at rod.savard at tetratech.com?

    Thanks

    Was this answer helpful?

    0 comments
  5. Anonymous
    2014-11-23T19:57:11+00:00

    Hi, what about this:

    I have the same file, in 2 versions containing slightly different data and heavy conditional formatting. Both versions were created in Excel 2010, but the data in the second (most recent) was edited in Excel 2013. 

    Today, I tried to copy in Excel 2013 some bits of information (in only a single row, but in 2 different column ranges) from the old file to the new one (pasted as values). And now, the absolutly puzzling thing:

    • If I paste in the first range, the destination file saves ok;
    • if I paste in the second range and the source file is still open, I get the "calculation incomplete" error. If I close the source file, the destination file always saves ok. Hence, I suspected the source file is the cuplrit.
    • nevertheless, the source file itself always always saves ok.

    To add to the crazyness, the destination file saves ok even when the sourec file is open, if no changes are made to the destination file since the last save. It *also* saves of when editing is done in the first cell range (see above) but fails to save if editing in the second range, even though both editing modify values in linked cells (i.e., trigger calculations).

    This absolutely sucks, I would never expect such a mess - even from Microsoft...

    Was this answer helpful?

    0 comments