Microsoft KB Archive/292298

= XL2000: Workbooks with Multiple ActiveX Controls May Open Slowly =

Article ID: 292298

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q292298



WARNING:This information is preliminary and has not been confirmed or tested by Microsoft. Use only with discretion.



SYMPTOMS
When you try to open a workbook that contains multiple ActiveX controls, you wait for an unusually long time before the file opens.



CAUSE
The Temp folder may have too many files in it. When you save a workbook with attached ActiveX Controls, Excel tries to save an .exd file and a .twd file to the Temp folder. Excel has to search through your Temp folder to see whether these files are there. If the Temp folder contains many files, the time it takes to save these two files increases.



RESOLUTION
Back up and delete all the files in the Temp folder. To empty the Temp folder, follow these steps:
 * 1) Restart your computer to a command prompt. In Microsoft Windows 95, press F8 when you see the &quot;Starting Windows 95&quot; message, and then select Safe Mode Command Prompt Only from the Startup menu.

For Microsoft Windows 98, restart your computer, press and hold down CTRL after your computer completes the Power On Self Test (POST), and then select Safe Mode Command Prompt Only from the Startup menu.
 * 1) At the command prompt, type set, and then press ENTER. Note the location of the TEMP variable.
 * 2) At the command prompt, type CD\, and then press ENTER.
 * 3) Type MD MYTEMP, and then press ENTER to create a new backup folder for the Temp folder files.
 * 4) Type CD\pathname\TEMP, and then press ENTER, where pathname is the path for the Temp folder.
 * 5) Type DEL *.TMP, and then press ENTER to delete the unnecessary .tmp files from the Temp folder.
 * 6) Type COPY *.* C:\MYTEMP, and then press ENTER to copy all of the remaining files to the MyTemp folder.
 * 7) Type DEL *.*, and then press ENTER to delete the remaining files in the Temp folder. Click Yes to confirm the deletion.
 * 8) Restart the computer.

