Select the product you need help with

XL2000: Workbooks with Multiple ActiveX Controls May Open Slowly

Article ID: 292298 - View products that this article applies to.

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.

Expand all | Collapse all

SYMPTOMS

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

Back to the top | Give Feedback

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 to the top | Give Feedback

RESOLUTION

Back up and delete all the files in the Temp folder. To empty the Temp folder, follow these steps:

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

Back to the top | Give Feedback

REFERENCES

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

199830

(http://support.microsoft.com/kb/199830/EN-US/ )

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

(http://support.microsoft.com/kb/299372/EN-US/ )

XL2000: File Opens Very Slowly

Back to the top | Give Feedback