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.