Thread: Pivot table
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot table

The Refresh Every x Minutes option is only available when the pivot
table is based on external data. If your pivot table is based on a table
in Excel, you can refresh the pivot table manually, or use programming
to refresh it when the data changes.

Hamido Azab wrote:
I have a pivot and I need to refresh data every same time, but I haven't to
select the refresh every check box, because it's hide



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html