How to save a workbook without redoing all calculations

[JenniferMurphy]

I have a worksheet with a table containing 60,000 rows and 12-13 columns. Several of the columns have paired columns that calculate the rankings of each value in that column against the entire column. Because it takes several minutes on my creaky old XP laptop to calculate those rankings, I have the workbook set to Manual, not Automatic, calculations. But whenever I save the workbook, it appears to redo all of the calculations, which takes 10-15 minutes or longer.

Is there some way that I can save the workbook without doing any calculations?

Thanks

 

[MARK858]

Possibly try...

Sub SaveNoCalculate()
    Application.CalculateBeforeSave = False
    ThisWorkbook.Save
    Application.CalculateBeforeSave = True
End Sub

 

[Ron Coderre]

File.Options.Formulas.Calculation_Options:
Check: Manual
UN-check: Recalculate workbook before saving

Does that help?

 

[MARK858]

Ron, will not changing it in Options change it for all workbooks and so it will need resetting for other workbooks? I haven't tested it, just asking

 

[Ron Coderre]

Yes, it will....
But,
...Change the setting
...Save the workbook
...Change the setting back, if desired.

 

[MARK858]

Yes, it will....
But,
...Change the setting
...Save the workbook
...Change the setting back, if desired.

OK, I just think if you are doing it that way (and it is a regular task not a one off) it is easier to assign a macro to a button or the QAT... but that would only be my personal preference, thanks for responding

 

[JenniferMurphy]

File.Options.Formulas.Calculation_Options:
Check: Manual
UN-check: Recalculate workbook before saving

Does that help?

Thank you, that saved me quite a bit of time.

 

[JenniferMurphy]

Ron, will not changing it in Options change it for all workbooks and so it will need resetting for other workbooks? I haven't tested it, just asking

Ron's solution solved my immediate problem. I'll look into your macro when I get a few minutes free time. Thanks.

 

[JenniferMurphy]

OK, I just think if you are doing it that way (and it is a regular task not a one off) it is easier to assign a macro to a button or the QAT... but that would only be my personal preference, thanks for responding

I agree. A macro is the way to go, but I just needed a quick solution so I could get the ****ed workbook saved.