This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
I have the same problem with only one page in a macros workbook that a coworker built in 2010....it only happens on tab. I am thinking it is one type of formula that excel 2013 does not like
I have Excel 2007, 2010 and 2013 running on my same box.
I have 6000+ excel files that have evolved templates over the past decade.
This problem only happens to me when I open files that have the latest version of my conditional formatting template in Excel 2013. If I open the same file in 2010 I have no problems.
It is a huge PITA and I will not roll out Excel 2013 to the company until it is fixed. If I had the time I would disable the conditional formatting formula's one by one to try to figure out the problem. Unfortunately I do not have the time. I will happily send the template to Microsoft and let someone in India or the Philippines figure out though.
This was my problem.
When I had auto calculation on, and I clicked "save", it kept on asking me
"Calculation is incomplete. Recalculate before saving?"
And I couldn't get past that no matter how many times I clicked.
I fixed it up by unticking auto calculation. And going to the recent sheets that I changed and on the "formulas" ribbon, clicked "calculate sheet". The "calculate" button did nothing, but "calculate sheet" fixed it.
Then turned back on the auto calculation and clicked save and it didn't ask me that any more.
Thanks.
Did your solution fix it permanently?
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.