I Can’t Believe Excel Didn’t AutoSave!
I get back to my desk the other day and my computer is on a green screen with “installing updates… 45%” or whatever (yes, I’m a PC user). No big deal, everything auto-saves, right!?
An hour later I open the spreadsheet I had worked in for several hours and all my work was GONE… I couldn’t believe my eyes. Finally “1 document found in AutoRecover”, I think “whew, maybe we’re ok”… clicked it, it too had none of my work from that day.
I haven’t had this kind of problem since… oh 1999!? So literally almost 20 YEARS!
I check the folder Excel has set to store the AutoRecover files (AppData\Roaming\Microsoft\Excel\) and there’s just 1 file; an XLB that does nothing when opened.
Locate a Support Chat on the Microsoft website, finally get connected after several tries. Tell him everything, he takes remote control and goes “Here’s your file. It’s right here”. Okay Mr. Smarty Pants, you didn’t read anything I wrote. “See the timestamp? It’s from 30 hours ago. I worked in it all day today.”
He goes into my Control Panel and checks and unchecks a few boxes in File Explorer Options. Back in the Excel AutoRecover folder, all these new, previously hidden files show up! I’m thinking “YES! These all popped up in the right folder, they’ve gotta be the AutoRecover files!”.
He does a few more things then says “I’m sorry, I’m not sure why your file didn’t AutoSave. I cannot help you. Have a good night”. I jump in the chat “Wait! What about all those files that appeared!?!?”.
He says “Those are all XAR files, not AutoRecover files. I don’t know what they’re from or why they’re there.” But he proceeds to click one anyway and BAM! There’s my missing work! I say “well, I guess we’re learning together!” which totally insulted his ego I’m sure. He says “those are graphic design files, I’m not sure why they saved that way. Is there anything else I can help you with today?”. I tell him “no, but please spread the word to your colleagues at Microsoft! I couldn’t find anything online about this problem and I can’t be the only one”.
So, in case I’m not the only one…
Excel AutoRecover Files are now XAR files apparently…
and Microsoft Office Support doesn’t even know yet!
FYI on Microsoft Office Version: I was using the “Free 30 Day Trial” of Office 365 – Excel 2016 was already on this new laptop, just with no license.
About the Author
I'm Abby (Armstrong-Lehman) Buzon, Owner & Lead Designer of The Helpful Marketer, based in Medina County, Ohio. I got my start in marketing and website administration in 2010, became a mom in 2015, and left my day job in 2017 to begin The Helpful Marketer. I'm happier than I've ever been and I truly love what I do, so I'm here to share my story and give some marketing tips along the way!