All worksheets in document are not saving!

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I just saved and closed an Excel document that contained about 20 worksheets.
When I reopened the file, all of the worksheets, except the top one are
gone!! This is about 6 hours of work gone in a heart beat. I'm using
Microsoft Office Mac 2008 on a MacBook Pro, Excel version 12.2.0. Is there
anyway to recover these worksheets from the autosave file, and how to I find
it? More importantly, how do I keep this from happening again? The file
extenstion was a csv file, so could that be the problem?

I would appreciate any help.
Thank
 
Christine,
Not so certain that you can recover the work at this point.

However, the .csv extension was probably the cause of the issue. Didn't you
get a warning to the effect that "some of the features ... incompatible with
..csv format"?

CSV files can only have one sheet.

Suggestion: as you open it up again to recover your 6 hours of hard work
(and I seriously sympathize with you, not trying to be snide), immediately
use Save As and change to a standard Excel file type. Then begin your
rebuild.
 
Back
Top