[PivotRefreshState enumeration The state for refreshing pivot tables. Values Name Value Description Success 0 Successfully refreshed UnsupportedExternalDataSource 1 Refresh failed because the data source is external.]