Excel - Stop it auto-calculating on Open

TheBramble

Legendary member
Messages
8,394
Likes
1,170
Says it all really. I want to look at the values that were last saved in a spreadsheet that is currently closed.

If I open it, it will automatically recalculate.

I've tried opening it in Notepad and other exotics...doh!
 
try :

tools/options/calculation/manual

rog1111

TheBramble said:
Says it all really. I want to look at the values that were last saved in a spreadsheet that is currently closed.

If I open it, it will automatically recalculate.

I've tried opening it in Notepad and other exotics...doh!
 
hmm, there's a way to change the global settings via VBA, I haven't done this for ages


TheBramble said:
Thanks Rog. But I have to open the file to do that and that's when the re-calc will occur.
 
The calculation mode applies to all open workbooks. Therefore the answer is to open Excel, set calculation mode to manual, and THEN open your workbook. That should do it.
 
TheBramble said:
swando & rog. Thanks.

I will post the VB code this evening to do this....The code will do the following:

When you open a spreedsheet in excel it will stop the auto calc for that instance of excel...it will not effect other instances of excel that are open....On close it will turn back on auto calc....

will post the code later....
 
slap this in the "ThisWorkbook" vba sheet of the spreaddy in question

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub

sets calc to manual (affects all workbooks)
 
A totally non helpful suggestion about how to solve the problem but..
this tells you how to do a bit of car racing if you have Excel 2000 ;)

1. Open Excel 2000.
2. Go to File, Save as Web Page.
3. Then Click Publish.
4. Check the little box that says "Add Interactively With"
5. Click Publish.
6. Close Excel.
7. Open IE
8. Click File,Open, Browse.
9. Go to where you saved it and click open
10. Now you should be looking at a spreadsheet.
11. Go all the way to row 2000.
12. Click column A and drag all the way to column ZZ
13. Hit Tab and it should take you back to A.
14. Hold Tab all the way to WC. When you get there make sure WC is a white box and all the others are green
15. Hold ctrl + alt + shift and left click on the four puzzle piece thing (The MS Excel Logo) in the upper left hand corner.
http://www.eeggs.com/items/8240.html Ice Viper
 
Top