Forum Discussion
Pivot table exceeding size
I have a pivot table with 87K rows and 5 columns, when I tried to refresh the data, I got an error for "pivot table does not fit on the sheet." However, from the public documentation on size limit, ...
In the source table, many many rows (I don't even know). I do have some filters on there.
Check if your filters (including the exact column names) exist in the source data.