Forum Discussion
Pivot table won't refresh.
Pivot table won’t pull today’s numbers for each adjuster even though the data source covers entire worksheet and field is set up to count per adjuster name. What am I missing? HELP!!!
Thanks, ...
Hello,
you don't need to include the whole worksheet as the data source. If not all rows are populated, that is a waste of resources.
Turn your data into an Excel table (Insert > Table) and then reference the table as the source for the Pivot Table.
Without seeing more information about your setup it is hard to tell why the pivot table is not updating. Check the data source settings of the pivot table.