How do I recover data that somebody pasted over on the wrong page

[Guest]

An employee copy and pasted to the wrong page into a worksheet that had very
important information on it and lost all the data that was there and then
saved it. Is there someplace to recover the data to the time before he saved
it incorrectly?

 

[Gord Dibben]

Not unless you have a backup copy of the workbook.

Perhaps your IT people backup everything on a daily basis?

Did you email the file to someone recently and they could email you a copy?


Gord Dibben MS Excel MVP

 

[Guest]

"Not unless you have a backup copy of the workbook" - Gord Dibben

THE definitive answer for this one. It's also the reason that we do a daily
backup where I work of all critical business files. You don't know how often
I have to retrieve a backup file to recover from exactly this kind of
operator error.

I keep daily backups for the past 5 days and for the previous week on line
at the office. Weekly backups for every week are stored off-site.