Prev: Cell Formatting Defaults To Scientific
Next: Move tab bar
From: Christine on 23 Apr 2010 10:35
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
From: JLatham on 23 Apr 2010 10:41
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.

"Christine" wrote:

> 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
 | 
Pages: 1
Prev: Cell Formatting Defaults To Scientific
Next: Move tab bar