Excel spreadsheet vanished!

[apir]

Hi,

I was working in an important excel spreadsheet when I got a message saying there was a problem with the file and that I needed to open some temp file and rename it.

Unfortunately I cancelled the message before reading it properly.

When I tried saving my excel spreadsheet I got a message saying I could not save. I tried Save As and renaming it but still wasn't allowed to save it.

After exiting the file I tried to find it and open it, but it had disappeared. I searched for it and it's gone.

Here are a couple details:

Operating system is Vista Home Edition
Excel version is from Office 2000
The spreadsheet contained a macro - maybe this was a problem...

Has anyone ever experience this before? Is there somewhere on my PC this spreadsheet might be hiding?

Thanks.

[AnnMarie]

Hi apir. I think the default location for Excel temp files in Vista is the C:\Users\<user name>\AppData\Local\Temp folder.

[apir]

Hi AnneMarie,

Thanks for your help. I looked in my Temp folder and could not find the spreadsheet. Any other ideas?

[apir]

Hi,

I found the file. The file type was just "File" and the document name was just a bunch of numbers and letters. I opened it and it asked me what program to use. Then everything opened up properly in Excel and I resaved it. So it's a happy ending.

Thanks for your help.

[Miz]

I've had that happen to me in MS Word. I copied the entire document and pasted it into a new document before trying anything else. At least that way I still had it should whatever I chose to do next be the wrong thing.

Whether that will work with an Excel spreadsheet with a macro without losing any data, I don't know. On the other hand, having even most of it copied and pasted would be better than losing the whole thing. ;)