Excel worksheets

[Diane Hanley]

I had multiple worksheets in an excel folder. On many
occasions I send these worksheets to various managers thru
email as an attachment and on that attachment I delete
what worksheets I do not wish for them to see.
Unfortunately, I didn't realize it was my actual worksheet
and I deleted all the worksheets with the exception of one
and I lost them all. It was not in the recycle bin. Is
there anyway I can recover these worksheets. I tried to do
a restore from Windows XP, but that didn't work either.

Appreciate any help.

 

[EZ Money]

It sounds as if your standard practice does not include making backups. If
that is true, you are probably out of luck. Have you ever sent the entire wb
as an email attachment? If so, you can retrieve it, assuming you or the
recipient still have the message.

 

[Gord Dibben]

Diane

You get your original data back only if you have a backup of the original
file.

You may have a backup if you are on a server and mass backups are regularly
made.

Look for any *.XLK files. If you have set options to always create a backup,
there could be a copy of the original saved as an *.XLK.

Are you running Norton Utilities Protected Recycle Bin? Easy to get an
earlier copy using Norton Unerase feature.

Otherwise...........out of luck, but much wiser......right?

Gord Dibben Excel MVP XL2002

 

[cheshirekat]

I had multiple worksheets in an excel folder. On many
occasions I send these worksheets to various managers thru
email as an attachment and on that attachment I delete
what worksheets I do not wish for them to see.
Unfortunately, I didn't realize it was my actual worksheet
and I deleted all the worksheets with the exception of one
and I lost them all. It was not in the recycle bin. Is
there anyway I can recover these worksheets. I tried to do
a restore from Windows XP, but that didn't work either.

Appreciate any help.

I'm fairly new to Excel, but to avoid losing your worksheets in the future,
you would be better off to move copies of the worksheet(s) you want to send
to a new workbook file.

If you right click on the worksheet name tab, you get options to insert,
delete, rename, copy, etc. the selected worksheet. AFter choosing the "move
or copy" option, you can then move or copy the worksheet to an open workbook
or a new workbook. Just make sure you don't ignore the "copy" option.

Also, you might want to get in the habit of saving your sent e-mail
messages. You can then retrieve the missing worksheets from previously sent
messages in the absence of a backup of your files.

 

[radio848]

Hi Diane:
In your EMail program, you might check the sent folder and see if you might
be able to rebuild the worksheets from there. Just a suggestion.Also, you
could check the hard drive temporary internet folders and possible retrieve
them from there. I don't know how far apart your managers are, so that may
be a chore.
As a future suggestion: One thing that I do is: make a manual backup of my
(in this case "Budget" folder to an appropriate storage device). I just copy
all of the xls files to a separate HD or zip drive, etc..
Here is hoping that this has helped you..
Take care!