Excel 2000 : Delay in loading spreadsheet 1

[w2rus]

Hi,

Can any anyone shed any light on this problem

I have a 1.6MB spreadsheet / Visual Basic project

The xls files is sharded from a server to a total of 30 machines and has been working with no problems for around 2 years.

A Windows 98 SE workstation, 128MB Ram, Office 2000 SP3 is experiancing the following.

When you first open the spreadsheet, you get asked if you want to enable or disable macro's, which is normal.

Once you have made a decision there is now a 4 minute approx delay before the sheet loads, it normally takes around 10 or 15 seconds. Once loaded everything works fine, all the macros etc until you exit the sheet and then there is a long delay again whilst excel closes. It doesn't matter if you enable or disable the macro's, the same delay is present.

No other machines have this issue and other spreadsheets work ok.

I have tried opening the sheet from a local drive, reinstalling excel, turning off AV software, more memory in the machine.

The computer does not have any other issues

Any ideas

Thanks in advance

W2rus

 

[KenWright]

Try the following:-

Clear out any temp files from the machine. Try deleting ALL the files and subfolders in your \Windows\Temp directory (Win95/98/ME), or your \Documents and Settings\<user>\local settings\temp directory (Win2K/WinXP). These can build up over time and cause Excel to open files very slowly. See MSKB Q299372

Text above from the following link:-

http://www.decisionmodels.com/optspeedd.htm#OpSave

Then if that has no effect try deleting the *.xlb file which is the toolbar customisation file. This will obviously blitz any customisations and reset it. Excel 2000 has a problem where this file can become bloated and eventually corrupt.

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[w2rus]

Thanks Ken

The answer was the temp folder

Thanks again

Walrus

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------