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

Hi Chrisso

Empty your temp folder first

Reboot
StartRun
Enter: %temp%
Delete all files and filders in the temp folder
Try again



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chrisso" wrote in message oups.com...
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

Thanks for the suggestion Ron.

I followed your advice but I am afraid that the problem persists.

I have no problem opening other much larger xls with more VB code so
maybe this suggests this is not the problem or I would see the lag with
every xls I open.

With this problematic xls when I open it, Excel springs to life and
displays "Opening <file" in the status bar, shows a window without
actually showing anything inside of it - then about 20 -25 seconds
later my Workbook_Open event is called. Weird.

The only unusual thing about this spreadsheet is that it is always
used(and saved) by the user with a vertical split/arranged window
showing a sheet from this spreadsheet in each window. In fact, this is
what my Workbook_Open logic does when it is called.

Thanks for the idea though - much appreciated. Any other ones will also
be gratefully accepted.

BTW - I have used your Excel site in the past - it is excellent. Thanks
for publishing all that stuff.

Chrisso


On 24 Jan, 14:44, "Ron de Bruin" wrote:
Hi Chrisso

Empty your temp folder first

Reboot
StartRun
Enter: %temp%
Delete all files and filders in the temp folder
Try again

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Chrisso" wrote in ooglegroups.com...
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- Hide quoted text -- Show quoted text -

Hi Chrisso

Try code cleaner on the file
http://www.appspro.com/Utilities/CodeCleaner.htm

Maybe it is corrupt
You can copy the sheets to a new workbook and drag your code modules to the new workbook.
The save this file and see if this file is working OK

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chrisso" wrote in message oups.com...
Thanks for the suggestion Ron.

I followed your advice but I am afraid that the problem persists.

I have no problem opening other much larger xls with more VB code so
maybe this suggests this is not the problem or I would see the lag with
every xls I open.

With this problematic xls when I open it, Excel springs to life and
displays "Opening <file" in the status bar, shows a window without
actually showing anything inside of it - then about 20 -25 seconds
later my Workbook_Open event is called. Weird.

The only unusual thing about this spreadsheet is that it is always
used(and saved) by the user with a vertical split/arranged window
showing a sheet from this spreadsheet in each window. In fact, this is
what my Workbook_Open logic does when it is called.

Thanks for the idea though - much appreciated. Any other ones will also
be gratefully accepted.

BTW - I have used your Excel site in the past - it is excellent. Thanks
for publishing all that stuff.

Chrisso


On 24 Jan, 14:44, "Ron de Bruin" wrote:
Hi Chrisso

Empty your temp folder first

Reboot
StartRun
Enter: %temp%
Delete all files and filders in the temp folder
Try again

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Chrisso" wrote in ooglegroups.com...
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- Hide quoted text -- Show quoted text -