Excel Slicer error when link to column with (blank) value

I have a template that has pivot and slicer in different worksheets that reference a “data” worksheet. The data worksheet gets populated by Aspose.Cells and refresh. When the user opens the file, they get the following message:

“We found a problem with some content in “… xlsx”. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes”. (See attachment)

We are able to open the file and save it locally. Opening it again from the saved copy will not produce the same error.

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and use the latest version: Aspose.Cells for .NET v8.8.1.4 and see if it makes any difference and resolves your issue.

If your issue still occurs, then please provide us simple sample console application and source excel file(s) used in your code, replicating this issue with the latest version. We will then reproduce this issue at our end and investigate it. If it is a bug, we will log it in our database so that it could be fixed by product team. Thanks for your cooperation in this regard.