This error appears to occur as a result of MS Office upgrades (i.e. to Office 2010) but may occur under other circumstances. It results indirectly from failing to have a windows\Temp folder into which Excel wants to write some supporting files.
To correct the error:
1. Exit all Excel processes.
2. Find and delete all files with .exd extension in one of the two following locations where USER is your Windows username:
for Windows XP: c:\documents and seettings\USER\Application Data\Microsoft\Forms\
For Windows 7 or Vista: C:\Users\USER\AppData\Microsoft\Forms\
or C:\Users\USER\AppData\Roaming\Microsoft\Forms\
or C;\Users\USER\AppData\Local\Temp\VBE
Alternatively, do a search for *.exd on the C: drive if you are having trouble locating those files in the above locations. NOTE: We have found a regular windows search on Windows Server 2003 sometimes does not find these files. If no .exd files are found with a general search, navigate directly to the path indicated above (where USER is replaced by the windows user name) and delete .exd files found there.
To correct the error:
1. Exit all Excel processes.
2. Find and delete all files with .exd extension in one of the two following locations where USER is your Windows username:
for Windows XP: c:\documents and seettings\USER\Application Data\Microsoft\Forms\
For Windows 7 or Vista: C:\Users\USER\AppData\Microsoft\Forms\
or C:\Users\USER\AppData\Roaming\Microsoft\Forms\
or C;\Users\USER\AppData\Local\Temp\VBE
Alternatively, do a search for *.exd on the C: drive if you are having trouble locating those files in the above locations. NOTE: We have found a regular windows search on Windows Server 2003 sometimes does not find these files. If no .exd files are found with a general search, navigate directly to the path indicated above (where USER is replaced by the windows user name) and delete .exd files found there.
3. You may also want to create a "Temp" folder within your c:\Windows folder if it does not exist, as a container for future .exd files if Excel needs to create them.
4. Reboot, then try your report again.
Deleting these files will not significantly affect your usage of Excel. If Excel needs them, it will automatically re-create them in a proper way the next time they are needed.
See this Microsoft article explaining the purposes and effects of deleting these files: http://support.microsoft.com/kb/290537
For users of MasterMine for GoldMine, we have prepared the following simple batch file to delete .exd files from the user's App Data\Microsoft\Forms\ folder: http://www.mastermine.net/files/PurgeEXD.zip (no warranty, no liability assumed)
Here is another resource that may be helpful in deleting "temporary" files that can be troublesome for Excel's smooth operation: http://www.add-ins.com/temp_file_deleter.htm
4. Reboot, then try your report again.
Deleting these files will not significantly affect your usage of Excel. If Excel needs them, it will automatically re-create them in a proper way the next time they are needed.
See this Microsoft article explaining the purposes and effects of deleting these files: http://support.microsoft.com/kb/290537
For users of MasterMine for GoldMine, we have prepared the following simple batch file to delete .exd files from the user's App Data\Microsoft\Forms\ folder: http://www.mastermine.net/files/PurgeEXD.zip (no warranty, no liability assumed)
Here is another resource that may be helpful in deleting "temporary" files that can be troublesome for Excel's smooth operation: http://www.add-ins.com/temp_file_deleter.htm
If the above does not solve the issue, another step to try:
1. Open the .xls file in question and click OK after getting the error mentioned above.
2. Open the Visual Basic Editor (Alt+F11)
3. Open (if they are not already open) one of the modules or code behind forms
4. Click on Tools / References...
5. In the pop-up window click on Browse...
6. Navigate to [Your Windows Directory]\System32 (it may open by default)
7. Type MSCOMCTL.OCX (you'll see it in the auto-select options before you finish typing)
8. Click Open and the reference will appear as Microsoft Windows Common Controls 6.0 (SP6)
9. Save the file and retry.
2. Open the Visual Basic Editor (Alt+F11)
3. Open (if they are not already open) one of the modules or code behind forms
4. Click on Tools / References...
5. In the pop-up window click on Browse...
6. Navigate to [Your Windows Directory]\System32 (it may open by default)
7. Type MSCOMCTL.OCX (you'll see it in the auto-select options before you finish typing)
8. Click Open and the reference will appear as Microsoft Windows Common Controls 6.0 (SP6)
9. Save the file and retry.
No comments:
Post a Comment