XL2000: Workbooks with Multiple ActiveX Controls May Open Slowly (292298)


The information in this article applies to:

  • Microsoft Excel 2000
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 "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.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

199830 OFF2000: EXD Files Are Created When You Insert Controls


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:

299372 XL2000: File Opens Very Slowly

Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbprb KB292298
©2003 Microsoft Corporation. All rights reserved.