I created a workbook that has a ton of formulas and a few macros in Excel 2003 and tested the workbook with the end user community. After we released the workbook for production processing people in the field started getting the following error after saving and trying to reopen:
Excel found unredable content in 'filename.xls' Do you want to recover the content of this workbook?
This is happening intermittently and the file open no problem in Excel 2010 without any error's reported. I have to figure out why this is happening as there are about 100 instances of this workbook in the field right now and this is happening to about 15 of the workbooks. I did find circular references in one case but not all when I opened in 2010 and eliminating all circular references fized the problem and I was able to open in 2003 again without losing anything. This was only true in one case though and I can not find circular references in any of the others that had errors. Has anyone ever seen this happen before and is there a logical solution?