I have attached one sample application. I am using ASPOSE.Cells version 220.127.116.11.
I have one excel file which is created in MS Excel2007(as .xlsx) but saved in the .xls format using Save as=>(97-2003 MS Excel format) option in MS Excel 2007. I have copied it into the bin/debug folder of sample applicaiton attached. This file contains two worksheets. "Summary" and "Data". The "Summary" worksheet contains cells having references(Cell.Formula feature) to data on "Data" worksheet.
Here if I insert one worksheet between these two worksheets using worksheet.Move method the references for cells on the "Summary" worksheet goes to the new worksheet. This is creating problem for me.
But this case is not happening if I create file on MS Excel 2003 and insert new worksheet on it.
I have spent lot of time in figuring out the problem but I am not able to succeed.
Please help ASAP.