mircosoft excel

  • Thread starter Thread starter Guest
  • Start date Start date
Assuming you haven't as yet saved the file *after* you delete the sheet (hope
so this is the case), then just close the file without saving. Re-open.
 
Assuming you have already saved the file, THAT file cannot be "repaired", as
such. Your only hope is if you backed the file up, or emailed it somewhere,
or if you are on a network and your MIS dept can supply a backup copy from
some previous timeframe..........

Vaya con Dios,
Chuck, CABGx3
 
You cannot "undelete" a worksheet. When you told Excel to delete it, Excel
gave you message: "Do you permanently want to delete the data?" You must
have answered yes. Excel was not kidding.It's gone unless by chance you have
a backup file. It's always best to make a backup copy of the workbook by
simply saving the workbook with a different name, reopening the original and
then deleting the sheet. This way you always have the sheet in the backup
workbook. Sorry you lost your data. You can also make a copy of the sheet
you intend to delete and keep it in your current workbook. Simply select the
sheet, press CTRL and move the sheet to anywhere you want in the sheets and
Excel will make a copy it in the workbook. For example: If you copy Sheet1,
the copied sheet's name will be Sheet1 (2). Then you can delete Sheet1. And
later if you find that was a mistake, you have its copy: Sheet1 (2) right
there in your workbook.
 
Hi,

Are you refering to Worksheet as pages in a Workbook?.

You can retrieve your lost sheet, even if have permenantly deleted the
sheet, provided you dont save the Workbook.

You can just close the file without saving and re-open the workbook again,
you will find your worksheet again.

Challa Prabhu
 
Hi, Max.

I was trying out on my system and now after your response I noticed that you
have replied to it. I apologize for repeated response.

Challa Prabhu
 
it's ok, Challa. no need to apologize. you missed the significance of the
<g> at the end. complementary responses do add variety and are always
welcome.
 
Back
Top