Calculate single sheet only?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 28 Feb 2007 13:58 GMT

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

Reply to this Message

Niek Otten - 28 Feb 2007 14:10 GMT

Hi Alan,

SHIFT-F9

Or Tools>Options>Calculation tab>Calculate Sheet

Signature

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
[quoted text clipped - 9 lines]
|
| Alan

Reply to this Message

GaryA - 28 Feb 2007 22:41 GMT

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

Alan;7328505 Wrote:

> I am using excel 2002 and have a large workbook litteredwith
> complicated formulas. As I input large amounts of data, the
[quoted text clipped - 9 lines]
>
> Alan

Signature

GaryA

Reply to this Message