Excel 2010 Help

[Dazzawm]

I am using Excel 2010 and it has an autosave option if you forget to save changes when you close your workbook. I have looked for it in its default location and when I attempt to open it all there is is a grey screen with all my normal excel taskbar options. Why is this please? Thanks.

 

[RoryA]

Are you using the File-Recent-Recover unsaved workbooks option?

 

[Dazzawm]

Yes. I want to get it sorted and see how it works just in case the worse happens!

 

[RoryA]

Do you actually have any unsaved workbook?

 

[Dazzawm]

Yes, I did it with a test workbook. I opened a copy workbook, made some changes, closed without saving and then the said problem occurs.

 

[RoryA]

I've not heard of that problem before. Can you just clarify the exact steps you take when you say: "I have looked for it in its default location and when I attempt to open it all there is is a grey screen with all my normal excel taskbar options"

 

[Dazzawm]

I dont really know what else I can say. I looked in options>save and saw where the autosave file location is, looked for it, opened it and hence the problem. I know it was the file because of the time and date on it. Also the file size seems to be smaller than the original.

It seems to be just like the problem you get in 2007/2010 when you open a new excel document but it is just a grey screen and you have to go to new and select new page.

 

[RoryA]

That does not sound like using the File-Recent-Recover unsaved workbooks option. It sounds like you did something through Windows Explorer, which is why I was asking.

 

[Dazzawm]

Ok, could you explain please how I use the option correctly then. Thanks.

 

[RoryA]

Click File, then Recent, then 'Recover unsaved workbooks' (bottom right hand side) then choose your workbook.