Excel crash involving SQL Server

[Guest]

I have an Excel 2000 file into which I've been pumping exported query results (as new worksheets) from a SQL Server database. There are also a few pivot tables in the same Excel file, as separate worksheets.

Yesterday I exported a very small set of query results from SQL Server and suddenly couldn't open the Excel file anymore. Instead, I get the dreaded "Excel.exe has generated errors and will be closed" message. Looking for advice on how I might open (or fix then open) the file. For instance:

* Can I revert to an earlier version of the Excel file somehow? Like early Monday morning ... (Again I'm in Excel 2000 and Win 2000 not XP.)

* I can read the Dr. Watson crash log but the results don't mean anything to me. Can this enable me somehow to open or roll back the file? How?

Thanks. - Rick

 

[jeff]

Hi,

I'm no expert, but I'd first make sure your Excel program
still works fine with other, simpler Excel files.
Then, I'd certainly give your latest backup file a try.
It should go out to query your SQL Server as normal and
retrieve the current data. If this fails, then you may
need to double check that your SQL tables are ok and
readable.

Congrats, at least, for having a backup!!
jeff

-----Original Message-----
I have an Excel 2000 file into which I've been pumping

exported query results (as new worksheets) from a SQL
Server database. There are also a few pivot tables in the
same Excel file, as separate worksheets.

Yesterday I exported a very small set of query results

from SQL Server and suddenly couldn't open the Excel file
anymore. Instead, I get the dreaded "Excel.exe has
generated errors and will be closed" message. Looking for
advice on how I might open (or fix then open) the file.
For instance:

* Can I revert to an earlier version of the Excel file

somehow? Like early Monday morning ... (Again I'm in
Excel 2000 and Win 2000 not XP.)

* I can read the Dr. Watson crash log but the results

don't mean anything to me. Can this enable me somehow to
open or roll back the file? How?