Earl Wrote:
Since the conversion, I can edit the stored query or simply refresh the
data and save
the workbook and everything seems fine, but when I try to close the
file, Excel crashes.
I think:
I found a similar problem and it was fixed by following the suggestions
in a Microsoft Technet article:
WORKAROUND
==========
To troubleshoot this error, attempt to isolate the problem to corruption
in
the Offitems.log log file, which is located in your Windows folder.
To check for corruption in the log file, follow these steps:
1. Close all programs.
2. Rename the Offitems.log file (to Offitems.old for example).
3. Restart Word or Excel, open a file, make a change to the file, save
the
file, and then close the file.
4. If the error does not appear, the problem has been isolated.
5. If the error reappears, close Word or Excel.
6. Find the file called OLE2.REG and double-click the file name.
7. Click OK.
Also, are you running the latest patch for Office SR-1? That fixes a
lot of issues. You can download it from Microsoft's Web Site.
douglas
Douglas Brown
PC Support
Bombardier Services, Defence
|