How do I get a Pivot Table to automatically refresh when the data source (in
the spreedsheet) is refresh.

I am refreshing the data source from the value of a cell on the same sheet
if that helps?

Tia