Excel takes forever to shut down

[Albert]

Hi!
One of the computers on my network has Win98 and Excel2000.
The user works with an ultra-large array (40000 X 13). The computer works
surprisingly fast, until shut down time arrives.
After saving his work, the user tries to close the workbook and it takes for
ever! I assume it has something to do with the Ultra-large array being
allocated in the memory, but none of the other computers (which use XP) seem
to have this problem. I have already tried using an END on the BeforeClose
event for the WorkBook, but there was no improvement. Is there any way around
this issue?
Best regards,
Albert C

 

[NickHK]

Albert,
With XL2K on W2K I had to use an array of nearly the whole worksheet cells
to get a serious delay in tearing down the array ; 40000 x 13 was no real
problem.
Adding End or Erase made no difference.
Maybe to do with the hardware/Win98 regarding RAM and/or paging, rather than
Excel per se.

NickHK

 

[Dave Peterson]

One thing that excel does when it closes is update the Toolbar.

You may want to close excel

Find your toolbar file (name and location will change with versions of excel and
windows, but it'll have an extension of *.xlb)

Rename it to *.xlbOLD

And reopen excel and test it out.

Then close excel.

If it works, delete *.xlbOLD and rebuild any customized changes.

If it doesn't work, rename the *.xlbold back to *.xlb (no harm done).