akphidelt wrote:
There might be a more effective way of doing it. But if you click on the
pivot table, right click... go to PivotTable Wizard.

Then in the wizard click "back" once. Then change the last number there to a
very large number like 50,000.

Then on your pivot table just click on hiding blanks... and it will never
show up and you'll always be able to refresh.

Best idea I've used is to set the pivot table's data range to full columns.

And hide blank categories.

Never another worry about missing added data.