Turned Off Calculation; Cannot Turn Calculation It Back On Again

[snapfade]

Hi,

This is gonna sound crazy. I have a pretty complicated workbook with many interrelated worksheets and formulas and macros galore. In an earlier copy of it there was so much data that any change became a time drag. So I started turning off calculation upon leaving a worksheet and re-enable upon activation. Along the way I found other supposedly helpful ideas to speed up processing. Here are the ones I have used.

Application.ScreenUpdating = true/false
Application.DisplayStatusBar = true/false
Application.Calculation = xlCalculationAutomatic/XlCalculationManual
Application.Calculate
Application.EnableEvents = true/false
Application.PrintCommunication = true/false

Today I have spent about three hours with that workbook (and much less data) and it seems nothing I do brings the Workbook back to normal. In some cases, a formula reports zero even though it was just a concatenation of two adjacent columns. In another case if I click F2 and then enter the right result shows but when I copy that formula down the column the same exact result is what appears in all the other rows. These results occurred after I tried turning off this or turning on that. There are no circular references nor does error checking find fault. I have restarted the system a couple times on somebody's suggestion but that did not help either.

I am almost certain I caused this problem with one or more of the above commands. Unless somebody has a specific suggestion for undoing what I have done, my question is if there is a macro that can query Excel for all settings and parameters. Perhaps I could run such a procedure against other, working worksheets, compare results and make the necessary adjustments to my errant workbook.

Thanks for your time.

[mikeTRON]

and if you go to Formula -> Calculation options it is set to automatic? It does not sound as such...

[snapfade]

Thanks Mike. Automatic calculation is turned on. As you can see from the various VBA commands above, automatic calculation is not the issue...or at least not the whole issue. Take a closer look at the bizzare behavior...that is not attributable to simply having calculation turned off. I did something else to cause this. It does not happen on other workbooks. And in the workbook in question, it happens on ALL of the worksheets. I am stumped. Any thoughts out there? Thanks.

[snapfade]

I have transferred the formulas and data to a new workbook and find that there is no problem. I have concluded that the file was probably corrupted. Closing this thread as solved. Thanks for looking.