| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spreadsheet takes 20 seconds to open before Workbook_Open
Hi All
I have a 4.4Mb spreadsheet with a bunch of VB code behind it. When I open the spreadsheet it takes upwards of 20 seconds before even the Workbook_Open event is called (I have a MsgBox on this event so I know when my logic gets control). What is Excel doing during this period? How can I decrease this period or eradicate it altogether? I dont have this problem with other spreadsheets that are much larger and have even more VB code. The file is on my desktop so there is no network issues. There are no links in the spreadsheet so it is not updating. Any ideas? Chrisso |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Takes 30 Seconds Plus to Save First Time | Excel Discussion (Misc queries) | |||
| Saving takes 30 Seconds | Excel Discussion (Misc queries) | |||
| Copying single cell takes 15-20 seconds | Excel Discussion (Misc queries) | |||
| macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting | Excel Worksheet Functions | |||
| Save takes seconds vs. SaveAs/Save As takes minutes | Excel Programming | |||
Threaded Mode
