Restoring an Excel file

[GC2012]

Just had a nightmare with Excel, whilst updating our stock list the iMac crashed and I had to shut it off manually.

After being re-booted I noticed excel had not saved (even though its on Autosave?) and the last stock book I can dig up through recent updates was from about 6-8 weeks ago and things has changed a lot since then.

Does anyone have any tips on how I could recover the original, I tried going on file then restore but no luck. As this one has autosaved its just taking me back to it.

We have typed it out again but short by a few thousand so could do with the original file to see whats missing.

[jammie*dodger]

What version of Office are you using? Do you have an o365 account associated or just a local account?

[GC2012]

Version 15.14 it says.

I do have a 365 account although never actually logged in and used it.

[Captain Morgan]

Can you not access your time machine backup?

[raringtogo]

Dont know if it works on Mac but in Windows you do the following:

Open Excel from main menu
On the left at the bottom select "open other workbooks"
When list appears on the right, scroll to the bottom and click "recover unsaved workbooks"

Hope that helps

That's All Folks

[jammie*dodger]

Version 15.14 it says.

I do have a 365 account although never actually logged in and used it.

Ok, so office 2016. Shame you didnt sign into o365 as it would probably have been keeping an incremental backup with version control on "the cloud" but no point worrying about that now.

This might help https://support.office.com/en-us/art...0-4f038402ff02

[Griswold]

Dont know if it works on Mac but in Windows you do the following:

Open Excel from main menu
On the left at the bottom select "open other workbooks"
When list appears on the right, scroll to the bottom and click "recover unsaved workbooks"

Hope that helps

That's All Folks

This.

[Mr Pointy]

I realise it's too late for the OP but consider keeping files like this on Dropbox. It retains multiple versions of files & you can even track who last saved or deleted a file.

It's quite embarrasing when you start a mini witch-hunt & find it was you that did it.

[GC2012]

Sorry for the late reply guys.

Unfortunately the file was a gone and we couldn't get it back, after a few hours the stock book is back up to date!

We will be printing a hard copy of it every week from now on in case this happens again.

Bloody computers!

[Mr Pointy]

I'm not sure printing out a hard copy is really the answer; maybe you need to look at your backup procedures (if you have any). If you're running a business think about Office 365 & save your files to Onedrive or use Dropbox as I indicated previously. It's not a total solution but it sounds as if you'll be in a better place than you are at the moment.

If nothing else make sure you have Autosave & Autorecover enabled:

https://support.office.com/en-us/art...f-a80415b92f99

[Captain Morgan]

I'm not sure printing out a hard copy is really the answer; maybe you need to look at your backup procedures (if you have any). If you're running a business think about Office 365 & save your files to Onedrive or use Dropbox as I indicated previously. It's not a total solution but it sounds as if you'll be in a better place than you are at the moment.

If nothing else make sure you have Autosave & Autorecover enabled:

https://support.office.com/en-us/art...f-a80415b92f99

Ideally also set up a time machine backup so that documents are saved in multiple places, as you’ve found out missing documents are a pain in the backside.

This would give you three copies of your data, your Mac, the time machine backup, and the online duplicate (OneDrive or Dropbox)