Excel 2007 Hanging on save in Windows 8

[thunderboom]

When I try to save changes a second time (the first save works) to a file in Excel it hangs & becomes unresponsive. If I exit and then try to reopen the file through "recent documents" I'm unable as the file cannot be found. The file cannot be found in documents or anywhere else, it seems to have completely disappeared. This is extremely distressing as I've lost large files which I've held for a long time! I'm at a big loss here...can someone please help or give me suggestions.

My Microsoft Office is the 2007 version. I have Windows 8.

[Murf]

1. Browse to the following location: depending on which bit version is install
C:\Program Files\Microsoft Office\Office 14 32 bit 2010
C:\Program Files(x86)\Microsoft Office\Office12 64 bit 2007
2. Locate the file EXCEL.EXE
3. Right click on the file and then click on the Properties option
4. Click on the Compatibility tab
5. Uncheck ‘Run this program in compatibility mode
6. Uncheck ‘Run this program as an administrator’
7. Click Ok
8. Verify the status.

Click the Office (2007) button.
Click Excel Options.
Click Advanced.
Scroll down to the General section.
Make sure that the check box "Ignore other applications that use Dynamic Data Exchange (DDE)" is clear (not ticked).
Click OK.

[thunderboom]

Thanks Murf. All boxes you mentioned were already unchecked. I've been running excel without a hitch for several days now without a hitch. Mind you, I'm sticking to only saving workfiles once and then exiting. I'm afraid to save more than once should the problem still exist.

[Murf]

Where are you saving them? One Drive?

If you search for *.xlxs are they where they are suppose to be?

Right click Windows flag, bottom left from desktop then go to Search, type in

*.xlxs to see where they are?

[thunderboom]

They are in their usual places. Some in One Drive/Documents, others in This PC/Documents. The files I lost last week completely disappeared. It was as if they never existed.

[Murf]

If you remember the name of the spreadsheets, do a search for the name only maybe find it?

[thunderboom]

I did do that & checked everywhere with no luck. What is funny but sad is the file name showed in the "recent documents" in excel. That was the only remnant that remained. I've been using excel and/or lotus since the late '80s. I've never experienced anything like this before.

[Murf]

In recent it should show the location of the file? i.e., D:\Spreadsheets

Does it? Files just cannot disappear...

[thunderboom]

Yes, the recent documents would indicate the file was in it's usual location such as Documents\ or C:\Users\Bernie\SkyDrive\Documents\

That said, the files could not be found there or anywhere else.

[Murf]

WOW this is really strange, Check to make sure the files are not hidden?

From the Control Panel, type “folder” in the search box and select Folder Options.

Check show hidden files.......etc

Still not there?

[renegade600]

are you doing a save or save as? whichever one you use, try the other. also try deleting all temporary files on your computer.

[smurfy]

Bear in mind I haven't used One Drive for cloud storage but...

Does any of this or this help for files you had saved in the cloud?

As for the locally stored files, I admit I am as perplexed as the other helpers here. Did any of the files have excessively long filenames?

[thunderboom]

I did check for hidden files. No luck there.

[thunderboom]

There were no problems if I saved once & did not exit. The problems occurred on saving a second time. I have resorted to saving once and then exiting the document, then reopening. No problems with this approach. I files I lost initially seem to have evaporated into space.

[thunderboom]

In the direction for restoring deleted files in One Drive it says "Tap or click Recycle bin at the bottom of the left pane." There is no recycle bin in the left pane so this confuses me. One of the files I lost did have a long name.