Problem adding a filters to a Pivot Table

GemBox.Spreadsheet
1

Hi, I have a problem when I add filter in this way:

Dim pfSubarrendado As PivotTables.PivotField = table.DataFields.Add("Subarrendado")
table.PageFields.Add(pfSubarrendado)

When I open the excel file I obtain this message:

image
image697×175 9.5 KB

Insufficient memory to create the pivot table report. To free up memory, try the following:

  • Reduce the number of column or row fields to include in the report.

  • Close any files or programs you are not using.

But my data have a few fields 2 row fields and 1 column field.

And the data source have only 15 columns and 675 rows.

What can I do please?

2

Hi José,

Can you please send us a Visual Studio project that reproduces your issue so we can investigate it?

Regards,
Mario