Calculation is incomplete. Recalculate before saving?

[Dr. Logic]

Has anyone figured out how to make this silly thing stop popping up in Excel 2016 yet?

! Calculation is incomplete. Recalculate before saving?


Yes No Cancel


It won't let you save a large file unless you click the NO button every time - it's a nuisance

 

[Asala42]

I haven't personally run into this issue but I found someone post what worked for them from
Excel 2013 "Calculation is incomplete. Recalculate before - Microsoft Community

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.

-HTH

 

[Dr. Logic]

Thanks for looking that up but unfortunately it does not work. It will stop it for one time only - it will not stop it for all the next times you save your file.

I guess there is no answer for this problem. Looks like a bug in excel that can't be fixed.

 

[JenniferMurphy]

This is very old thread, but I ran into this error message for a completely different reason than I have seen mentioned here or elsewhere.

I was working on a little project in a workbook with 8-9 sheets. I was working in one sheet with a UDF. I had set up a breakpoint and was stepping through to see what it was doing. I found something that I needed to check out, so I went to a different sheet and was doing some calculations when I got interrupted. When I came back a couple of hours later, the second sheet was still open, but the formulas were not working unless I opened each cell. When I tried to save it, I got that "Calculation is incomplete" error message. I check the automatic calculation setting and everything else I could think of. Nothing worked.

I searched for this error and found several threads on 4-5 forums. But none of them seemed to address my problem and most of them were several years old. A couple of people said it started with Excel 2013.

Eventually, I noticed that I had the VBE open. Then I saw that my UDF was still in break mode. Hitting F5 solved everything.

My guess is that is started with 2013 because before that, you could not go back to a sheet if a UDF was in break mode. So it's not a bug in Excel. It's a bug in Excel's error messages. It should say that there is a UDF in break mode. That would have saved me well over an hour of my life. If I had all of the wasted time back that I have spent chasing M$FT stupidity, I'd be 20 years younger and less irritable.

 

[benalt]

I've come across the problem periodically. I just ran a macro where it happened in the last stages. I ran it a second time with the same result. I attributed the problem to a corrupt PERSONAL.XLSB file which happens to me every now and then and I usually consider this when something that has been working suddenly does not. What I did just now was to remove the PERSONAL.XLSB file and recreate it from scratch by copying in backups of all the modules I have from text files I have with my backups (I back up the PERSONAL.XLSB file as well as having text versions of the modules). I then saved and reran the macro without any issues.

I actually have an old PERSONAL.XLSB file I once named PERSONAL.XLSB.good which I copy in to place whenever I think the current PERSONAL.XLSB file is corrupt to save time setting things up before I overwrite the modules with the most recent versions of them. I also noticed that when I save PERSONAL.XLSB, it usually has become a much smaller file compared to the corrupt one.