| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate on Status Bar causing VBA to run very slow
I have a workbook which has exceeded Excels limit of 65,536 dependencies. Consequently I have the 'Calculate' message on the status bar. This does not pose any problems. However, if the user executes some VBA code, the length of time time taken to execute can be several minutes for code that can normally executes in seconds. Is there a way to force a recalc (F9 or alt+ctrl+F9) and then instruct VBA to execute procedures without being slowed down by Excel? Or have I interpreted incorrectly what Excel/VBA is doing? Any help will be greatly appreciated. Kind regards, Darren. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does 'calculate' show in the status bar, even after i hit F9? | Excel Discussion (Misc queries) | |||
| Macros Causing Workbook to Run Very Slow | Excel Discussion (Misc queries) | |||
| calculate message in status bar | Excel Discussion (Misc queries) | |||
| 'Calculate' message at the status bar | Excel Programming | |||
| What's causing file to increase in size and slow program? | Excel Programming | |||
Threaded Mode
