$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
---