disable calculations of a specified sheet

[ebeyert]

All,
I have Excel 2007 and a Excel file which contains multiple worksheets. One worksheet (HR Planning) has many formulas which causes that the calculation of the other sheet cost a view seconds. I know that you can setup the calculation options to manual, but this applies for the whole Excel file and this is not want I want. I want to have the calculation option to automatic, except for the worksheet HR planning. Is there option that you setup the calculation on manual for only worksheet HR planning?

Thanks in advantage,
Best regards
Ellerd

 

[wigi]

Ellerd

A quick Google search would have yielded pages like http://www.tek-tips.com/viewthread.cfm?qid=498924&page=1514

 

[brettdj]

A simpler alternative to the tek-tip example is to set the
EnableCalculation
property of that particular sheet to False

You can leave the workbook in Automatic Calc mode with this technique

- Alt & F11 to the VBE
- in the 'Project" window click the sheet that you want to set to manual
- in the 'Propeties" window set EnableCalculation to False

or with code
in the ThisWorkbook module you couls use

Private Sub Workbook_Open()
ThisWorkbook.Sheets(1).EnableCalculation = False
End Sub

to disable calculation on the first worksheet when the workbook opens

Cheers

Dave