Comments on Manual Calculation on certain sheets.

  • Thread starter Thread starter Laurence Lombard
  • Start date Start date
L

Laurence Lombard

I have a sheet in a workbook with array functions that slows down
performance with calculation on automatic (which I need for the other
sheets). Would it not have been useful to be able to set a single sheet to
Manual and update when needed in the same way Pivot Tables work?

One way to work around this is to save the Array Formula sheet in another
workbook.

I have browsed some of the posts on Excel's way of handling Automatic/Manual
recalculation and it seems as if there is room for improvement or are there
important reasons that I am not aware of?

Any comments.

Laurence Lombard
 
Hi Laurence,

It is possible to achieve this using Worksheet.enablecalculation from VBA.

FastExcel V2 has this capability (along with the ability to have some open
workbooks on manual calculation and others on automatic calculation), ( but
it is not free ...)

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
Back
Top