Excel Not calculating issue on one workbook

No.. I can force the calculations manually but if I set it to automatic, save and close the file, as soon as it is reopened, it has switched back to manual.

Hi there,

For what it's worth, I upgraded a (very useful!) freeware Add-In to the latest version, which the author had inadvertently saved with manual calculation enabled before distributing it. You can imagine how many "problem workbooks" were created as a result!

It took me quite a while to identify the source of the problem, and when I informed the author about it, an updated (automatic calculation) version was made available immediately.

The problem was solved by opening each "problem workbook" in turn, setting its calculation mode to automatic, and then saving it. The problems never returned.

As I said, just for information.

Regards,

Greg M

Do you remember the name of the add-in or a link to where you got it?

I tried the

Please Login or Register  to view this content.

No change, still have the same problem, but thank you.

Presently, I am backwards engineering the changes that I have made since the problem began. I have a known good wkbook that does all the calculations and retains the Automatic Calculation settings that was created on 040120. Luckily I try to keep copies of each workbook after each days changes. Since that time, I have modified two worksheets, and changed code in 8 modules.

Today, so far, I have made changes to two worksheets in the known good workbook and removed four modules and imported the same four modules from the workbook with the issue. So far, so good, everything is working fine. The next four modules have some extensive edits, so I will see how that goes.

This is an approach I have used in the past to correct issues, but I have never had quite the number of changes between workbooks. Two of the modules I will try next, does use power query, one for export to csv and the other import from csv files. If after completing this process everything works, then my only guess would be some sort of file corruption in the workbook with bad code. I will update later. In the meantime, thanks again for all the suggestions. Isn't troubleshooting code "FUN" ..!

Well, I removed and imported the remaining four modified modules. I also forgot about some edits I had made to the monthly sheets, but basically reduplicated the original changes. Everything is working fine. So all that I can deduct is that somewhere along the way the initial file I was working on got corrupted. I do remember a couple of times where the code hung up and I had to kill the process, and one time if I remember correctly I may have had to use task manager to end excel. So those may have caused the issue. However I am back to where I want to be... YEAH !!!!