Sunday, January 5, 2014

Office for Mac Asterisk Bug Fix That Works

Spent over 7 hours editing a paper already past due for publication to have every character turn to asterisks on Microsoft Office for Mac 2011 this weekend. Spent hours searching google for a fix and seems the world consensus is that whats lost is lost. More on that here-

http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macword/corrupted-document-all-of-my-work-turned-to/158a21b8-6e87-4de4-9659-105e0d5563c4?msgId=8aa4a864-63aa-45d1-b936-d2ea8e262649

and here-

http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macword/word-converted-my-text-to-asterisk/59799bcd-d076-483c-85c1-d12908208e69?msgId=fa1e392b-906a-4622-b221-7770c30914bf

and here-

http://word.mvps.org/mac/asterisksbug.html

But where there's a will, there's a way. Here's how you get your file back:

1) Word autosaves the file every 10 minutes (I actually have my autosave set on 2min). This file gets deleted as soon as you hit save (or Save As... in my case)
- the first thing I did when the asterisk bug hit is save my file as another document (original name f'ed up.doc). Big mistake as the auto recovery file was instantly deleted.

2) Download a file recovery software. I used Stellar Phoenix Mac Data Recovery. Pay the $99 for activation, you know what your file is worth to you.

3)  Click Recover Deleted Files. Go get 8 solid hours of sleep. You deserve it and it will take close to that long for recovery software to run.

4) In the file types- open documents, then open word files. There will be a list of countless word files, all without names (The naming scheme used in the operating system is part of the file system architecture, which becomes severed when the files are deleted. hundreds or thousands of files with names that are gone forever.)  You'd think organizing by modified date would help, but alas all the dates are gone as well. Just left with hundreds of word files.

5) Insert flash drive and recover all Word files to the flash drive (for some reason recovery software can't recover to same drive)

6) Now you have a folder on USB drive that has hundreds of files. Among them is the auto recovery file of your document.

7) How to find it? Several ways.
     A) Wait for spotlight to index the files (they'll have to be copied back to the hard drive). you can speed this long by going to Settings- Spotlight- Privacy- and add the folder you transferred to the hard drive to list of folders for spotlight to skip. Close out of settings. Go back in and remove the folder from the files to not index list.  Search.

    B) Find a file of approximately the right size (Compare to whatever version you have saved thats closest.) Arrange files by size. Keep opening files till you find it. (Tip: Use number of words to know if the autosave file is the most recent one available- more words usually means more recent)

8) Don't forget to update your Word (Help- Check for Updates) to the latest version with the bug fixed (it actually happened to me twice, shame on me.) You'll have to update twice to get to the latest version.

9) If I saved you a ton of work, help me pay off my student loan. PayPal accepted.

26 comments:

Anonymous said...

Took a long time but it worked!

Anonymous said...

Hi there, I just really want to thank you for posting this solution. I thought I had lost my master's thesis today when that stupid asterisk bug wiped out my document. I scoured the internet looking for a solution and yours was the only one that worked. The program you suggested was able to recover my whole document (at least I think it's the whole document, after the near-mental breakdown I went through today I can't even remember where I was at when it happened) in about one hour. If anyone here is reluctant to try this program because of the price, just know that you can download it off piratebay for free (although if you can afford to pay $100 then do so to support the developers). It's also worth mentioning again that the recovery did not take me 8 hours like your post says, but less than 1. Thanks again!

Dmitriy Golovyan said...

Glad to hear!

Anonymous said...

Hi Dmitriy,

I've tried everything but it hasn't worked for me yet. Any chance you could help me please?

I have added you on FB - happy to pay btw if it ends up working.

Thanks.

Philipp

Dmitriy Golovyan said...

Send me a Facebook message, I don't think I accepted that request

Anonymous said...

It must be in your 'other' folder.

Thanks!

Brjazgunova Kristina said...

Hey I just found your solution to the problem. However whenever I am trying to open the recovered file on the flash drive it says that the document uses a file type that is blocked from opening in my version/ or that document name or path is not valid. Do you think there is a way around this?

Brjazgunova Kristina said...

Hi! I tried your solution. but for some reason it did not work. Whenver I am trying to open a file on my flash drive it says that that either file type is blocked from being opened on my version or that document name or path is invalid. What do I do?

Dmitriy Golovyan said...

Not sure, haven't encountered that. I would try
1) trying to copy file to your drive from the usb before opening
2) try to open the file from word instead if double clicking from the file
3) maybe didn't recover properly- trying again, this time recover to a different usb
4) upload to google docs- see if google has an easier time opening it
6) good luck

Anonymous said...

thank you! it worked!

Dmitriy Golovyan said...

You're welcome. We're you the kne that had a hard time opening from usb? How did you finally make it work?

lisa robinson said...

I just had this happen to me. I was working on a very long document 250+ pages and it all turned to asterisk. I did not have automatic backup on or time machine activated. Now I only have a saved document that is full of asterisk. The corrupted document also is much less pages than my original documents. Are you saying that document recovery software can recover my document even under these circumstances? Thanks in advance for any advice you can give.

Anonymous said...
This comment has been removed by a blog administrator.
Dmitriy Golovyan said...

The principle here is finding a system file generated and then deleted by word during autorecovery. If you did not have auto save enabled, I really don't think it would work, however auto save is a feature that's On by default in this version of Word. Sure you you had it turned off?

lisa robinson said...

I thought autorecovery was on. It was at some point because I was able to find a version from one month ago in the autorecovery folder, but nothing more recent. Assuming there's nothing more recent in the autorecovery folder, it sounds like using the software isn't going to find anything more?

Dmitriy Golovyan said...

Run it. Just check your word preferences first and make sure that auto save is turned on. If it is- run the software- your file should be there.

kirra12 said...

Hi Dmitriy,
I have download the program however in the documents there are only a few word document and not my file. Do you know where else it might be?
Kirralee

Anonymous said...

Hi i have this problem and have downloaded the same software! i dont know how to use the software it doesnt seem to be working, please help im desperate!!

Ali said...

Hello Dmitrity,

I am extremely anxious. Please help me if you can. I have been writing my PHD thesis, and I went over 150 pages, however, I forgot to save the last 50 pages or so. I have encountered this stupid asterisk bug and so I immediately close the word ( as undo did not work). I clicked on the option " do not save" and quite. Once the file was launched again. I lost more than 50 pages of work. I got extremely panic and I went to the "Office 2011 auto recovery" folder hoping that I can retrieve my file, but the cruel fact is I did not find any file there for my last progress. I could only see the file that I saved last time, which is only about 96 pages (not 150 pages). I tried to disperately search for a solution in google, but most comments agree that it is lost. The only comment that gave me hope is yours. I downloaded your software (stellar pheneox) and I tried to scan for all files in the hard drive, but I could only see existing files or deleted files in the trash with their names and date, but none of them relevant. I could not see files without names as you suggested. Please help me if you can, I will be very grateful to you. I appreciate your time to read my comment

Dmitriy Golovyan said...

Facebook me

Anonymous said...

In step 3 you state that I need to click recover deleted files, but I am not really sure to which option you are exactly referring to?

Sarah Evans said...

Thank you thank you so much, Dmitriy! You saved me so much trouble!!! Even the reps from Stellar Phoenix said it couldn't be done when I called for help but I kept on trying because I knew you had done it and I finally got it to work!

Dmitriy Golovyan said...

That's great news, Sarah!

Dmitriy Golovyan said...

It sounds like a problem with the file system, I'd try to recover to a different USB drive.

Mamoon said...

HI
Cant say how grateful I am as you saved my day. My deadline for submission is in 2 days & I was just about to lose more than a 2 weeks worth of data. It really worked easily & as someone else mentioned as well, It took me under an hour to retrieve the document back from the instructions you provided. Again many thanks !!

Anonymous said...

Thank you, thank you, thank you! Worked perfectly! Saved a major assignment from going to hell. Will spread the word, wherever I can.