It was SLOW, now is FAST!

  • Thread starter Thread starter Phillips
  • Start date Start date
P

Phillips

I just found out about the xlCalculationManual option.

What are any known issues with it?
How can I turn xlCalculationAutomatic back on when I exit a userform?
Is there a way to force a manual recalc from a program?

Thanks
Phil
 
Activeworkbook.Calculation = xlCalculationAutomatic


ActiveWorkbook.Calculate

also see CalculateFull in xl2000 and later
 
Are there any "Gotchas" I need to worry about?

I do have filters set etc, some are based on time, what I am thinking about
doing is every 15 minutes, forcing a ActiveWorkbook.Calculate in an
OntimeManager function I already have installed. This might be a good time
to release my filters, and then reset them, to force an update of the data I
am working on....


Thanks
Phil
 
If your code gets interrupted and ends, either by Ctrl Break or by just any error,
calculation is still manual and excel don't work as intended. Silly minor problem that may
and probably will cause huge problems for any user that happen to be someone else than the
code author.
 
Tom,

With the ActiveWorkbook.Calculate, I got a "Run-time error '438':
Object doesn't support this property or method.
I am trying
application.calculate instead.
I would have just liked to have the current workbook calculated, but...

I am using Excel XP

Thanks
Phil
 
My bad,

Application
Worksheet
Range
all have calculate methods.

Application has calculatefull as well in xl2000 and later. In xl2002 there
is an even more extensive calculate command (rebuilds the dependency tree I
believe), but I don't recall what it is called exactly.
 
Would it be wise to put
calculate
in my macro that I use to set my filters? Several of the cells that I use
for the filter criteria are formulas.

Thanks
Phil
 
Back
Top