pivottable Table options - Refresh every <##> min is greyed out

[John Murphy]

I want to autorefresh a Pivottable when inputting data

 

[Debra Dalgleish]

That option is only available if your pivot table is based on external
data. Could that be the problem?