I am using excel 2007, not overly large 1mb or complex, no pivot tables. suddenly I have been getting the error upon openeing the file Excel found unreadable content in 'abcfile.xlsx' Do you want to recover the contents etc. I click yes then the box pops up stating removed feature: Hyperlinks from /xl/worksheets/sheet5.xml part

I am not using pivot tables. I don't have a sheet5. I did have about 100 hyperlinks that are now gone. What has happened? Why? How do I prevent it from happening again?

Any help would be greatly appreciated.