Reference error with the new Aspose.Cells dll

[sharanya_ps]

Hi,

We have a scenario where we are adding a reference of a cell from one sheet to a cell in other sheet.

We have been using Aspose.Cells version 7.5.2.0 and it was working well.

Recently, we have upgraded to 17.2.0.0. Since then we are getting ‘#REF!’ error.

I have attached a sample report where this issue is seen (Cells B31,B32 and B33)

Could you please suggest a solution

Thanks,

Sharanya

[shakeel.faiz]

Hi,

Thanks for your posting and using Aspose.Cells.

Please share your sample console application (with older version that is working fine and with newer version that is not working fine) project with your source excel file(s) which we could run at our end and replicate this issue.

We have checked your provided excel file and found it is referring to some external source (excel workbook) as shown in the screenshot. So it might be the cause of your issue.