In the attached ZIP file there is an XLS and an XLSX file. The XLS file is produced by Apose.Cells 22.214.171.124 though it has been opened by Excel 2003 and then saved again. The XLSX file was produced by saving this file as XLSX from Excel 2003.
When the XLS is opened, Excel 2003 complains that cell (Tables)!E1701 has a circular reference. While it has an INDEX expression that COULD be circular, it is not circular, and there is an IF statement to prevent the circularity. In fact, you can see a correct numeric value in that cell. If I just resave and reopen the file, I get the error again. However, if I select E1701 and press F2 followed by Enter, then resave and reopen, the warning moves to a new cell. This has been done to the cells with the orange background.
If I save the entire file as XLSX and open it, there are no complaints. Also, if we generate an XLSX directly from Aspose.Cells, there is no complaint, it opens fine, with no circular errors. If I open the XLSX and then resave it as an XLS, the new XLS opens fine.
I am convinced, on the basis of these experiments, that the formulas are all correct and that for some reason Aspose's XLS triggers this false detection in Excel. Can this be fixed?