Excel cannot open this file. The file might have been damaged ormodified from it's original format.

[Lane Beaton]

I managed to recover my file two ways:

1. I sent it to Patrick McMillan at Microsoft and he recovered it using a PC and he saved it to .xls
2. A buddy recovered it using iWork and exported it to .xls, this retained more of the formatting than the previous.

Many thanks to Pat, great support.

 

[S.T. Black]

I managed to recover my file two ways:





1. I sent it to Patrick McMillan at Microsoft and he recovered it using
a PC and he saved it to .xls 2. A buddy recovered it using iWork and exported
it to .xls, this retained more of the formatting than the previous.





Many thanks to Pat, great support.




Just like chime in that I too experienced the corruption issue and was able to recover it using the iWork import/export functionality.

The spreadsheet in question made heavy use of conditional sums but was otherwise fairly ordinary - no graphs, charts, enormous size, etc.

There was no prior crash/problem closing that would have been an obvious trigger for file corruption.

The file was saved in the .xlsx format.

I hope this issue is able to be identified quickly and resolved.

 

[Pat McMillan]

Thanks S.T. If you still have a copy of your file before it became corrupted
and could share it with me, I would love to investigate. Also, if you could
tell me that as best as you remember what steps you took with the file prior
to the last time you save it before it became corrupted it would be a great
help.

Thanks,

Pat
(e-mail address removed)

 

[Luis]

I had the same issue described in this post, tried renaming the extension of
my file to xml and xsl but Excel still had problems opening the file.

I spent a long time putting the data together in that spreadsheet, and now
it's lost. Can anyone help me recover the data in the file please?

Thanks,

Luis

 

[Pat McMillan]

If you can send me a copy of the file I can investigate.

Thanks,

Pat McMillan
(e-mail address removed)

 

[Luis]

Thanks for the follow-up! The trick of changing the file to .xml or .xsl
didn't work for me (I have a MacBook running office 2008.) I am lucky enough
to have Office for Windows too, and when I opened the file in Excel for
Windows the file corruption got fixed.

It would be nice to have that same functionality in Excel for Mac too.

Thanks again for the follow up!

Luis

 

[Pat McMillan]

Thanks. Yes, we're thinking seriously about file recovery for an upcoming
version of Mac Excel. I'll add your voice of support to the list.

Thanks,

Pat

 

[Li]

So, there doesn't seem to be any quick fix it is there? I was working on a spread sheet yesterday, and now its have the same described error. Renaming it doesn't seem to have helped.

 

[Pat McMillan]

I'm working with Li to try to figure how how the file became corrupted.

 

[stephencvargo]

I found a solution of sorts from this thread - <http://www.officeformac.com/ProductForums/Excel/1539/0>.

making a copy, and changing the extension to .xml worked.

I then re-saved the file over the old one as an xlsx and it saved and reopened fine.

I think what triggered it was the "Conditional Sum" I have going (it's under Tools), as it's the only thing unique compared to my other docs.

Anyone else have any experience with conditional sum and issues?

Changing a copy to .xml worked for me(Only had two files on my desktop that were affected)--Thanks!