pasted items to new workbook, deleted info in new wb, lost orig.

[AWolff]

My father had a expense spreadsheet for 05. He copied then pasted the
spreadsheet to a new workbook, creating a new 06 spreadsheet, then deleted
the 05 expenses that were in the new 06 spreadsheet. When he went back to
the 05 spreadsheet, it was blank. Is there any way to retrieve the data that
had been saved all year on the 05 spreadsheet?

A. Wolff

 

[Ken Wright]

Sounds like he may have CUT rather than COPIED. If he did this and then
saved his 05 sheet, the data is gone I'm afraid. Failing that maybe he has
a backup somewhere? If the file is still open and he hasn't saved then just
close it down without saving and it should still be there next time he opens
it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------