Update: Part 2 of the Article.
Its been a few months after the final version of Office 2007 hit the retail stores. And to be honest, I was happy and eagerly waiting for the final version to come out and lay my hands on it. I was also a beta tester for Office 2007 (I assume many were) and its new interface and compressed saved files than earlier versions of Office were its major plus points.
A few days ago, I encountered a serious problem. I was left aghast when, Excel 2007 was unable to open a file which was saved in Beta 2. The file was important & confidential and losing it would mean I was screwed badly. The error read was: This workbook was created in an earlier beta version of Excel 2007, and it cannot be opened in the current version of Excel. To open the workbook, you must first open and save it in Excel 2007 Beta 2, and then you can open it in the current version of Excel. The same error came in Word 2007 but was able to convert the file. WTF, why not Excel then?
The only lame solution it gave was to uninstall the final version and re-install the Beta 2. Come on, I don’t want to waste a few hours of my precious time, I need something quick. Another couple of solutions I found out was to modify the registry or run gpedit.msc. However, I found a much easier and hasslefree solution. I pointed my browser towards Google Docs. Here’s how I did it:
Open Google Docs
Upload the file
Uploaded file is shown
Export the file to .XLS format: File > Export > .XLS
Download the file and you’re done.
Now Excel 2007 will open this file under compatibility mode.
Rafael Franco says
You are a genius… I was looking for a solution like this for months!!
Thanks!!!!!
skyrl says
Fine work, but Google Docs don’t take XLSX files as input, only XLS. I don’t have the Beta 2 of Excel anymore, so i’m stucked with an unconvertable XLSX file with important accounting data in it…
I’ve tested the the microsoft “solution” with gpedit.msc or the registry : doesn’t work either – i’ve installed the microsoft office 2007 converter pack : doesn’t work.
I’m out of solution here.
Kunal Gangar says
An update of the article
http://www.techtickerblog.com/2008/01/12/part-2-aftermath-of-office-2007-beta-2/
Klaus says
Thanks for the info, worked first time for me. FYI, I changed the .xlsx extension to .xls before uploading.
Klaus
Ethel says
Thankssssssssssssssssss it worked……i had given up hope of retrieving the file and it was really important……