XL2000: Workbooks with Multiple ActiveX Controls May Open Slowly

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

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.

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 "Starting Windows 95" 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.
2. At the command prompt, type set, and then press ENTER. Note the location of the TEMP variable.
3. At the command prompt, type CD\, and then press ENTER.
4. Type MD MYTEMP, and then press ENTER to create a new backup folder for the Temp folder files.
5. Type CD\pathname\TEMP, and then press ENTER, where pathname is the path for the Temp folder.
6. Type DEL *.TMP, and then press ENTER to delete the unnecessary .tmp files from the Temp folder.
7. Type COPY *.* C:\MYTEMP, and then press ENTER to copy all of the remaining files to the MyTemp folder.
8. Type DEL *.*, and then press ENTER to delete the remaining files in the Temp folder. Click Yes to confirm the deletion.
9. Restart the computer.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
For additional information about how to troubleshoot slow performance when you open Excel workbooks, click the article number below to view the article in the Microsoft Knowledge Base: