Articles

Ms office 2007 Document data disappeared

June 29, 2010 at 16:52:00
Specs: Windows XP

All of my data in my documents disappeared. I have been told by others that this happens in MS Office 2007. How do I get it back?

ALL OF MY DATA IN MY DOCUMENTS DISAPPEARED. I HAVE BEEN TOLD BY OTHERS THAT THIS HAPPENS IN MS OFFICE 2007. HOW DO I GET IT BACK?

edited by moderator: Shouting Eliminated


See More: Ms office 2007 Document data disappeared

Report •


#1
June 29, 2010 at 17:25:30

You could start by asking your question without using All Caps, which is the Internet equivalent of shouting.


Report •

#2
June 30, 2010 at 08:13:31

Sorry, but to someone who can't see well it is not shouting it is being able to see what you typed. If I offended you it was not intentional. Pia

Report •

#3
June 30, 2010 at 09:16:21

Could you be a bit more specific as to what is happening?
Just All of my data in my documents disappeared is not much to work with.

Are we talking about Excel, Word, Publisher?

I have been told by others that this happens in MS Office 2007

Who told you and did they know why or how to correct the problem?

Are you having problems with other applications?

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 30, 2010 at 09:28:25

Hi Mike. Thanks for the reply. All of my word, excel and powerpoint data files in my documents disappeared.

The person that told me about it said that 2007 did this to him and he had a backup and the current data was not on it.

All of his files were 97-2003 Saved As. So he uninstalled 2007 purchased 2003 and put his backed up files in my documents and did a recovery for the 15 missing ones.

He had one heck of a time recovering them and ended up spending alot of money to recover them. Then he copied and pasted them on a new document and saved it in 2003.

And he has not had any problems since then.

I can't find out if 2007 has an auto-save. So I can find the temp file that they go in. I can't even find where to turn it on.

I too am going to uninstall 2007 and get 2003. I do not like it at all.

Hope this answers your questions. Pia


Report •

#5
June 30, 2010 at 09:29:08

No other problems with any other software on my computer.

Report •

#6
June 30, 2010 at 11:19:41

Hi,

To find the AutoRecover location, open Excel 2007
Click the Office button, and select Excel Options (at the bottom of the window that opens)
Select the Save tab (in the left hand side pane)
You will see if 'AutoRecover' is 'on' and also the AutoRecover folder location.

Also you will see the default file save location.
If it isn't 'My Documents' then go to that folder and see if your files are there.

Regards


Report •

#7
June 30, 2010 at 11:48:50

Have you tried running Diagnostics?


Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button

Click All Programs

Click Microsoft Office folder

Click Microsoft Office Tools

Click Microsoft Office Diagnostics

Click Continue

Click Run Diagnostics

See if that helps.

MIKE

http://www.skeptic.com/


Report •

#8
June 30, 2010 at 18:51:31

YES I DID RUN THE DIAGNOSTICS. THAT DID NOT HELP. BUT THANKS.

Report •

#9
June 30, 2010 at 19:13:31

What about Humar's AutoRecover suggestion?

All of my word, excel and powerpoint data files in my documents disappeared.

When was the last time you accessed the files?

Do they appear in your history file?

Is the "My Documents" folder on a separate drive from the normal C: drive?

Did you check to make sure they are not just hidden?

What is the exact sequence of events that you follow when saving a file?


MIKE

http://www.skeptic.com/


Report •

#10
June 30, 2010 at 19:38:47

Auto Save is on. I did a search for where the Auto Save Excel files went and I can't find anything.

C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\


Report •

#11
June 30, 2010 at 19:52:55

What about Humar's AutoRecover suggestion?
Could not find of my documents.

When was the last time you accessed the files? On 6/22/10.

Do they appear in your history file?
No they do not.

Is the "My Documents" folder on a separate drive from the normal C: drive?
No it is not.In My Documents on the C drive.

Did you check to make sure they are not just hidden?
Yes I did.

What is the exact sequence of events that you follow when saving a file?
Save as 97-2003.doc or 97-2003.xls.


Report •

#12
June 30, 2010 at 20:52:57

What is the exact sequence of events that you follow when saving a file?
Save as 97-2003.doc or 97-2003.xls.

Are you manually changing the extension to .doc & .xls or are you using the drop down list?

Have you tried saving as the default format .docx, or .xlsx to see if that works?

Have you tried saving to a different directory?


You could also try doing this:

Go to your "My Documents" directory and while sitting in the directory, open a new instance of Excel from the Start-Programs menu, then simply save a blank Excel sheet with the default name and immediately switch over to the "My Documents" and see if it is actually being saved, even for an instant. You could probably reduce the size of the Excel sheet so you can view the "My Documents" folder and see what occurs.

Have you run your antivirus software to see if you have any nasties? Also your antimalware software, like Malwarebytes?

MIKE

http://www.skeptic.com/


Report •

#13
June 30, 2010 at 22:27:25

Are you manually changing the extension to .doc & .xls or are you using the drop down list?

No I am not changing them. I use the drop down list.

Have you tried saving as the default format .docx, or .xlsx to see if that works?

Yes I had both types. .doc and .docs, .xls and .xslx.

Have you tried saving to a different directory?

Other than "My Documents"----no I have not.


You could also try doing this:

Go to your "My Documents" directory and while sitting in the directory, open a new instance of Excel from the Start-Programs menu, then simply save a blank Excel sheet with the default name and immediately switch over to the "My Documents" and see if it is actually being saved, even for an instant. You could probably reduce the size of the Excel sheet so you can view the "My Documents" folder and see what occurs.

They are actually being saved. Some had been there since Dec 2008. I did your suggestion and it saves it to "My Documents". But I still can't find the auto save file to check to see if they are being saved to there.

Have you run your antivirus software to see if you have any nasties? Also your antimalware software, like Malwarebytes?
I
have Malwarebytes installed and running on my computer and AVAST antivirus. This is the second time that this has happened. First time the recent ones had been backed up. This time the recent ones were not backed up.

MIKE

http://www.skeptic.com/


Report •

#14
June 30, 2010 at 22:30:46

What is a OPA12.bak and opa12.dat files?

Report •

#15
July 1, 2010 at 07:43:47

They are actually being saved.
So the files are being saved, but somehow being removed after being saved, correct?

What is a OPA12.bak and opa12.dat files?

Has to do with the MS Office License.
See here:

http://support.microsoft.com/kb/919895

But I still can't find the auto save file to check to see if they are being saved to there.

If you follow Humars' directions:
Open Excel 2007
Click the Office button,
Select Excel Options (at the bottom of the window that opens)
Select the Save tab (in the left hand side pane)

In the right hand pane, it should tell you the "AutoRecover file location" and the "Default file location"

The default location for temp files in Excel is
"C:\ Documents and Settings\<username>\Local Settings\Temp"
or
"C:\Users\<username>\AppData\Local\Temp"

The temp files for excel look like ~dfxxxx.tmp, with the leading tilde character.

Try doing a system search for the tilde mark followed by any character, like ~*.*

Make sure you check the "advanced option" in the search window.

MIKE

http://www.skeptic.com/


Report •

#16
July 1, 2010 at 15:04:51

Hi. I looked in all the temp files and there is nothing in the majority of them.

C:\Documents and Settings\Owner\Application Data\Microsoft\Word\ This is the auto save file for words.

C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\ This is the auto save file for excel.

There was nothing in these. Going to try your other suggestion. Thanks. Pia


Report •

#17
July 1, 2010 at 15:11:12

Your suggestion did not work. So I honestly do not know what the heck happened. I did a recovery with Recovermyfiles and it found them, but some where overwritten and some where corrupt. So now I need to find a good free software to fix corrupt word, excel, mp3 files.

Any suggestions?


Report •

#18
July 1, 2010 at 15:39:13

Glad you got some of the files back, but the question still remains:

Are the files are being saved, but somehow being removed after being saved?

If they are being saved, and then deleted or overwritten, then it would seem to be a system problem and not an Office problem.

Here are a couple of links to get you started in your recovery effort:

http://support.microsoft.com/kb/826864

http://office.microsoft.com/en-us/e...

MIKE

http://www.skeptic.com/


Report •


Ask Question