Calculate single sheet only?

A

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
 
N

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
|
 
G

GaryA

I had the same problem. I put this in my personal.xls and connected
it to a toolbar button. Then I use it to force a manual calculation
of the active sheet whenever I need.

Public Sub CalculateSheet()
ActiveSheet.Calculate
End Sub

Gary
 
Top