DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 292298 - Last Review: November 2, 2013 - Revision: 4.0

This article was previously published under Q292298
This article has been archived. It is offered "as is" and will no longer be updated.
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  (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

Applies to
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbprb KB292298
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support