Hi,

What do you want to trigger the refresh - something that happens in the
spreadsheet or some sort of time increment?

Where is the data relative to the pivot table - same workbook, different
workbook, or an external database such as Access?
--
Thanks,
Shane Devenshire


"Chris" wrote:

I have an excel sheet that requires me to push a button to enable
automatic refresh. Is there a way to make it automatically perform a
refresh so I don't have to push this button?

Thanks,
Chris