PC crashed - possible to retrieve spreadsheet?

purplepatch

My pc crashed while I was working on a spreadsheet and when I restarted and opened excel, there was nothing recovered. When I opened said spreadsheet, all the work I'd done on it today was gone as I hadn't saved .

Probably not, but before I do it all again, thought I'd ask the techies if there's anywhere the lost stuff might be.

Mr_Skint_2

Is it XP you are using?

paxy

Newer versions of Excle do have an autosave function. However if this was turned on I would have expected it to have recovered by now - so you may have lost your spreadsheet this time. Try looking in tools - options to see if you can turn it on for next time.

Mr_Skint_2

Well any way try this.

Open Windows Explorer (Click on Folders Icon at the top if need be), Tools, folder Options, View, tick, Show Hidden Files and Folders,
OK, Now Expand the tree Until you get to a Folder called Recent.

When you open Explorer you will automatically go to the My Documents folder.

Now click on the + symbol next to my computer, and then the + symbol on Local Disk (c), then + symbol next to Documents and Settings, and + next to Your logon name, then + next to Application Data, + symbol next to Microsoft, then + Symbol next to Office... Now is the file on the right hand side of the screen,,, If so click once on it
and then whilst still in explorer click on Edit, Copy to Folder, then choose My Documents then Copy and it will be abck in My Documents ready to work on as usual.

This doesnt always work mind you as the file could be lost totally.

Dont forget to rehide Files and folders as first described just do the opposite (tick hide files and folders.)

Example Picture

purplepatch

Mr_Skint wrote:

Is it XP you are using?

Sorry, back now, yes it's XP!

Mr_Skint_2

Ok I just typed and uploaded a walkthrough that could work.

purplepatch

Mr_Skint wrote:

Ok I just typed and uploaded a walkthrough that could work.

It just opened the same version with all the stuff I'd done today missing :wall:

Thanks for you help anyway, much appreciated.

purplepatch

paxy wrote:

Newer versions of Excle do have an autosave function. However if this was turned on I would have expected it to have recovered by now - so you may have lost your spreadsheet this time. Try looking in tools - options to see if you can turn it on for next time.

Probably an old version of excel but can't see it in tools options to turn on.

Anywhere else it might be?

Browntoa

found this

http://www.amset.info/tips/office-recovery.asp

might find a temp file if it created it

djohn2002uk

purplepatch wrote:

Probably an old version of excel but can't see it in tools options to turn on.

Anywhere else it might be?

To auto save in Excel you need to go to Tools/Add ins and select it there first. Then you will find it will appear in Tools. Click on it and you can specify how often and a few other things too.

gizmoleeds

Mr_Skint wrote:

Example Picture

Mr Skint - why do you have a file called "cillit_bang"? :rotfl: