View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default How do I recover an Excel worksheet that I erased?

Julian

If you have Autosave enabled you should have a backup avilable which could be no
more than 10 minutes old.

Look for *.bak if using Excel 2000 or earlier.

*.xlk if using 2002 or 2003

Since you have autosave.xla I am assuming 2000 or earlier but.........?


Gord

On Tue, 20 Jun 2006 07:16:02 -0700, JulianB
wrote:

I am using the AutoSave add-in. I closed a worksheet without saving.

"Gord Dibben" wrote:

How do you backup every 10 minutes?

Are you using AutoSave add-in or do you mean you have AutoRecovery set for 10
minute intervals?

If the latter, you can recover the workbook only if Excel crashes.

When you say you closed the workbook did you Save?

Helps if you know the proper terms to describe things.

An Excel WorkBOOK is a file which contains one or more workSHEETS(tabs)

A Spreadsheet is the generic name for any type of file produced by any
application that is similar to Excel and uses a series of rows and columns
producing cells for calculations.

An explanation by John Walkenbach...............

In the realm of accounting jargon a "spread sheet" or spreadsheet was and is a
large sheet of paper with columns and rows that organizes data about
transactions for a business person to examine. It spreads or shows all of the
costs, income, taxes, and other related data on a single sheet of paper for a
manager to examine when making a decision.

Now........what exactly did you "erase" and how?

A worksheet or the workbook?

Others replying have assumed it is a workbook/file you erased.


Gord Dibben MS Excel MVP



On Mon, 19 Jun 2006 13:37:02 -0700, JulianB
wrote:

I back up every 10 minutes. I did close the workbook. Is there any way of
recovering the workbook and or the spread sheet or is it too late

JulianB

"Gord Dibben" wrote:

A worksheet is part of a workbook which is a file.

Have you saved the workbook/file since the erasure of the sheet?

If so, your sheet and work is gone unless you had a backup.

If you have not yet saved the workbook/file just close without saving.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 11:29:02 -0700, JulianB
wrote:

I accidently erased a work sheet that I was working on. How can I recover the
work?