Phenomenal! Thanks for clarifying Max.

I have two questions remaining. I am sure I will feel silly when I realize
what you meant but can you explain this statement.

"By base, its meant that you create your own pivot w/o applying any hidden
items" I think I know but I want to make sure I got it right.

These are the steps I've been taking. Did I interpret all your instructions
correctly?
- Created the pivot table
- Return to its source data and delete it
- Entered new source data
- Return to pivot table, right click, and choose Refresh Data
- Click one of the downward arrows on the pivot table and de-select (blank)
so the blank rows of data are hidden.

Thanks for your time,

Jazz



"Max" wrote:

$A$1:$AI$500 that would mean change it to $A$1:$AI$60000
But that's simply too great an increase? Do a self estimate based on say,
the last 3 monthly variations in the extent (if its monthly data), then go
for the smallest increase just large enough

-Configure the base PT format
By base, its meant that you create your own pivot w/o applying any hidden
items

-Refresh the PT to recalc for any new data added
Right-click anywhere inside the PT, then click the exclamation button to
refresh. The pivot needs to be refreshed each time there's a change in
underlying source data
--
Max
Singapore
---