| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros Running Sometimes Slow Sometimes Fast | Excel Discussion (Misc queries) | |||
| why is moving a row slow in excel 2007 where it is fast in 2000 | Excel Worksheet Functions | |||
| Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
| searches slow on some computers fast on others? | Excel Discussion (Misc queries) | |||
| Searches slow for some Fast for others? | Excel Worksheet Functions | |||
Hybrid Mode
