Calculate single sheet only?

[Alan]

I am using excel 2002 and have a large workbook litteredwith
complicated formulas. As I input large amounts of data, the
calculation ( I have it set to calculate on close of F9 only) time
takes 3-4 minutes, as it is calucating every formula in every sheet.
I want it to only calculate on the active sheet, which will speed up
the process of data entry. Then once the data has been entered, it
can take its time calculating the entire workbook.

Any ideas?

Thanks!

Alan

 

[Niek Otten]

Hi Alan,

SHIFT-F9

Or Tools>Options>Calculation tab>Calculate Sheet

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am using excel 2002 and have a large workbook litteredwith
| complicated formulas. As I input large amounts of data, the
| calculation ( I have it set to calculate on close of F9 only) time
| takes 3-4 minutes, as it is calucating every formula in every sheet.
| I want it to only calculate on the active sheet, which will speed up
| the process of data entry. Then once the data has been entered, it
| can take its time calculating the entire workbook.
|
| Any ideas?
|
| Thanks!
|
| Alan
|