I have a dynamic named range that is a data table of bank transactions. How
can I have my pivot tables automatically update when I add data to the data
table? I would prefer not to have to click the refresh data icon on the
pivot table toolbar if possible.

I'm not sure if it's relevant but here's the formula used for the dynamic
named range: =OFFSET('Acct XXX'!$A$1,0,0,COUNTA('Acct XXX'!$A:$A),9)

Thanks,

Dave

--
Brevity is the soul of wit.