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 ":" i only wanted it to change anything showing a time or date & completely forgot all my finance side of things got effected. Now when i open the document ALL my money entrees are stuck showing the wrong amount & there's no way i can remember what they were.
I do have a backed up copy but it's a week or so old & not up to date.
I do know from looking at the backed up copy that for example if i change the "." in £11.90 then changes it to £0.46 (in the entree part at the top it says "0.464583333333333"
Can any PLEASE help me to get it all back to normal?
I really appreciate anyone's help
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 😞
