I am trying to troubleshoot a pivot table a colleague uses. The pivot table is currently 20,000 rows and is added to monthly. When the most recent month was added the pivot table wouldn't recalculate to include that data. I have checked the data range which was correct, formatted the data as a table and used the table as a range and checked all the field settings to ensure the pivot table is filtered correctly.
I can recreate the pivot table from the data and pull in the entire range, however as there are multiple calculated ranges my colleague doesn't want to do this every month.
Any suggestions?
Thanks in advance
I can recreate the pivot table from the data and pull in the entire range, however as there are multiple calculated ranges my colleague doesn't want to do this every month.
Any suggestions?
Thanks in advance