Calculation Order problem.

I

ICE9

Hhhm, unfortunately I'm using Office 2003.

There doesn't appear to be a solution, just information on how i
works. To make it even worse, some of the calculated cells on the dat
sheet are also part of named ranges. Each column is a named range fo
easy reference in SUMPRODUCT functions.

I would had to just be SOL... Isn't there any code I could place on
sheet to keep it from updating
 
M

Myrna Larson

If you set calculation to manual, it will only recalculate when you press F9.
Change the setting at Tools/Options/Calculation if this sounds useful.
 
C

Charles Williams

Its hard to tell exactly what the problem is without profiling the workbook,
but try this: it might solve the problem

assuming that the workbook is in manual calculation mode

sub IceTry1()
dim oSht as worksheet
application.calculation=xlmanual
application.screenupdating=false
for each osht in activeworkbook.worksheets
if not osht.name=""Summary" then
osht.usedrange.calculate
end if
next osht
application.calculate
end sub

let me know if it works for you.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
 
Top