Error with filters on a pivot table causes a corrupt sheet and memory error

[fizgig]

Pivot table works great until we add a filter on a yes/no column, then it gives:

then this error:

The pivot table appears on the sheet but is not populated

Without the filter on the billable column it works fine:

And you can manually drag the billable column down to be a filter and it works fine.

pivotTable.AddReportFilter(filterIndex);
is the only relevant code added, the column is a yes/no text field.

[fizgig]

We're getting a similar issue on
pivotTable.AddDataColumn(iDataCol, true);

[tonyqus]

Can you share the original Excel file?

[fizgig]

Timesheet_Report_08-10-2023 (2).xlsx
Here's the file

[fizgig]

Any update on this?

[tonyqus]

Timesheet_Report_08-10-2023 (2).xlsx Here's the file

This looks not to be the original file. It's a broken one. Can you upload the original one?

How did you add a filter? using C# by NPOI or Microsoft Office? If using C#, can you show me the code of adding this filter?