Set Calculation Options to Manual and uncheck "recalculate before save"
Add this event code to the worksheet in question.
Private Sub Worksheet_Activate()
Application.Calculate
End Sub
Only when you select that sheet will you calculate.
Note: if you open this workbook after a workbook with calculation set at
auto, this workbook will also be changed to auto-calc.
i.e. First workbook opened determines the calculation mode for subsequent
workbooks.
You have to be careful with this...................
Gord Dibben MS Excel MVP
On Fri, 14 May 2010 18:54:21 +0200,
wrote:
Thank you
Is there a way to ony make this calculate when the sheet (where I use
now() ) is opened?
On Fri, 14 May 2010 10:51:05 +0800, "ozgrid.com"
wrote:
You probably have Volatile formulas within. E.g TODAY,NOW etc These formula
recalculate every time you open the file or do most things in Excel.