Comments on Manual Calculation on certain sheets.

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
 
C

Charles Williams

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
 
Top