All worksheets in document are not saving!

[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

 

[JLatham]

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.