How it started.
I was at home and needed to edit a MS Excel 2007 file. Having OpenOffice installed (And only 2003 Excel), I used the Calc module to edit the document and saved the changes made.
Still In the Dark..
After multiple changes and updates on the document, I overwrote the copy on my flash drive. All is well.
…Saw the Light…Oh Oh!
I was however, totally unaware (that on saving) that some of the structural settings native to MS Excel 2007 were modified to function in OpenOffice Calc. I only discovered this issue when on opening, the file complained about being corrupt and the file was to send that day. Oh! Oh!
Attempts at Work
I tried File – Open – Open and Repair
I tried extracting the data from the file
I tried relocating file to the computer
I tried changing computers
I even tried installing a recovery software (unsuccessfully due to no administrative rights!!)
I tried searching for ways to recover file without installing software (which prompted me to pen this piece)
Whilst at home I attempted to open the file once more with the suspicion of something being wrong with the system at work or flash drive file. No such luck.
With a prayer and fingers crossed, I opened the file in OpenOffice Calc and …BINGO!!
It was all there. Nice and Open. I re-saved this time as MS Excel 2003. (Please note that this article in no way is to discredit the great creation that is OpenOffice. I have never had any issues with switching from any of the other components in OpenOffice to their counterparts in MS Office Suite, except with Excel 2007. )
After additional changes I was able to successfully open the file in Excel 2007 (compatibility mode) and so send the file to the respective recipient.
Lessons to To Be Learnt
Always save in the lowest compatible build i.e save in 2003 rather in 2007.
Always have multiple options (although they may be in different locations) and
Unless you are an I.T Manager or Something you will not have administrative privileges
If you have learnt any lessons from this or your own experience feel free to share.
- 5 Excel Troubleshooting Tips (mademan.com)