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

Hi Alan,

SHIFT-F9

Or Tools>Options>Calculation tab>Calculate Sheet

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Alan" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
|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
|