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