Forum Discussion
Desperately need help!
Hi there I recently made a massive mistake in excel! Even though i "discarded changes" problem still exists! I used the "find & replace all" function & wanted to replace all the "." with ":" ...
If you are on Mac, try Time Machine.
If you are on Windows, right-click the workbook file in File Explorer (aka Windows Explorer).
Select Properties from the context menu.
Activate the Previous Versions.
Wait a few seconds to see if the window gets populated.
If so, can you restore a version from just before you made the mistake?
Otherwise, I fear you are out of luck - some of the values can be restored by multiplying them with 24, but others have been altered beyond repair.
Many thanks for your reply & taking the time
I really do think I'm out of luck though. I just don't understand that when i chose "discard changes" that it didn't just go back to the way it was before the error!
Think I'm just going to have to take it on the chin & accept I've lost them 😞
I really do think I'm out of luck though. I just don't understand that when i chose "discard changes" that it didn't just go back to the way it was before the error!
Think I'm just going to have to take it on the chin & accept I've lost them 😞