LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JulianB
 
Posts: n/a
Default How do I recover an Excel worksheet that I erased?

Gord

I am using XP. I think it is too late to recover now. But I would like to
know how for the future.

Julian

"Gord Dibben" wrote:

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?








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how do i save a large amount of data in a worksheet excel 4 Rana Excel Worksheet Functions 1 June 13th 06 10:54 AM
Excel Open Dialog Improper Sort [email protected] Excel Discussion (Misc queries) 4 May 17th 06 02:40 PM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
Excel worksheet linking Shiren Excel Worksheet Functions 0 July 6th 05 05:33 PM


All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"