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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pivottable Table options - Refresh every <##> min is greyed out (https://www.excelbanter.com/excel-discussion-misc-queries/38620-pivottable-table-options-refresh-every-%3C-%3E-min-greyed-out.html)

John Murphy

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

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?

John Murphy wrote:
I want to autorefresh a Pivottable when inputting data

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 07:08 AM.