It was SLOW, now is FAST!
 

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

It was SLOW, now is FAST!
 

Activeworkbook.Calculation = xlCalculationAutomatic


ActiveWorkbook.Calculate

also see CalculateFull in xl2000 and later

--
Regards,
Tom Ogilvy


"Phillips" wrote in message
news:3Orvb.264534$HS4.2358979@attbi_s01...
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

It was SLOW, now is FAST!
 

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


"Tom Ogilvy" wrote in message
...
Activeworkbook.Calculation = xlCalculationAutomatic


ActiveWorkbook.Calculate

also see CalculateFull in xl2000 and later

--
Regards,
Tom Ogilvy


"Phillips" wrote in message
news:3Orvb.264534$HS4.2358979@attbi_s01...
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

It was SLOW, now is FAST!
 

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.
--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Phillips" wrote in message
news:3osvb.68923$Dw6.351321@attbi_s02...
Are there any "Gotchas" I need to worry about?

It was SLOW, now is FAST!
 

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



"Tom Ogilvy" wrote in message
...
Activeworkbook.Calculation = xlCalculationAutomatic


ActiveWorkbook.Calculate

also see CalculateFull in xl2000 and later

--
Regards,
Tom Ogilvy


"Phillips" wrote in message
news:3Orvb.264534$HS4.2358979@attbi_s01...
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

It was SLOW, now is FAST!
 

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.

--
Regards,
Tom Ogilvy

"Phillips" wrote in message
news:iSsvb.69097$Dw6.352034@attbi_s02...
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



"Tom Ogilvy" wrote in message
...
Activeworkbook.Calculation = xlCalculationAutomatic


ActiveWorkbook.Calculate

also see CalculateFull in xl2000 and later

--
Regards,
Tom Ogilvy


"Phillips" wrote in message
news:3Orvb.264534$HS4.2358979@attbi_s01...
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

It was SLOW, now is FAST!
 

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

"Phillips" wrote in message
news:3Orvb.264534$HS4.2358979@attbi_s01...
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