Excel 2007: Manual calculation

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

CreepinJesus

Thread Starter
Joined
Oct 18, 2007
Messages
23
Is there any way to set the calculation to manual for one worksheet only as opposed to the global setting ?
 

CreepinJesus

Thread Starter
Joined
Oct 18, 2007
Messages
23
So if I stuck the following code into the workbook in question:

Code:
Private Sub Workbook_Open()
   Application.Calculation = xlCalculationManual
End Sub
It would open under Manual calculating, even if Excel is set to automatic before-hand ? Also, would this keep Excel set to Manual after it has been closed and opened again ?
 
Joined
Sep 24, 2007
Messages
869
If U don't turn off Macros, and do not change this property after opening the workbook, then it should work fine!
 
Joined
Jul 25, 2004
Messages
5,458
You really must read the links I posted, they explain what you are asking. This may - or may not - be the case.
 
Joined
Oct 20, 2004
Messages
7,837
did you read this line from the MS page? "In Microsoft Excel, all currently open documents use the same mode of calculation, regardless of the mode in which they have been saved."
and this
"To recalculate only the active sheet, use one of the following methods:
• Press SHIFT+F9.
• In Excel 2003 and in earlier versions of Excel, click Options on the Tools menu, and then click the Calculation tab. Click the Calc Sheet button to calculate only the active sheet.

In Excel 2007, click Calculate Sheet on the Formulas menu in the Calculation group."
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top