Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel runs slowly in the background
I am calling an Excel session from another application.
When run from the GUI (and Excel has focus), the Workbook takes about 0.2 seconds to recalculate. When called from my VB application however, recalculation takes around 25 seconds. When run from the Excel GUI and Excel does not have focus, recalculation also takes 25 seconds. I've seen other messages that describe the same problem and associate the slow down with the difference between a foreground and background Windows process. This does not seem to be the complete problem because even if I increase the priority of the Excel process, I cannot significantly improve performance. Any recommendations on how to improve recalculation performance of background Excel sessions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
Excel Spreadshhet will not close, runs in the background | Excel Discussion (Misc queries) | |||
WHY the same macro runs so slowly on a different but faster comput | Excel Discussion (Misc queries) | |||
Excel runs slowly, but only when connected to a network | Excel Discussion (Misc queries) | |||
Macro that runs in the background | Excel Discussion (Misc queries) |