ExcelBanter - Pivot Table Data Refresh

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

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

- - Pivot Table Data Refresh (https://www.excelbanter.com/excel-discussion-misc-queries/930-pivot-table-data-refresh.html)

patemarie

Pivot Table Data Refresh

Can something be done to automate a refresh to Cube data in a pivot table in
Excell 2003?

tjtjjtjt

Choose Table Options from the PivotTable menu or by Right-Clicking on the
PivotTable. Then, you can set the Refresh to happen when the file opens and
every x numbers of minutes of your choosing.
Excel normally refreshes the data automatically, if you ever pivot the table
as well.

tj

"patemarie" wrote:

Can something be done to automate a refresh to Cube data in a pivot table in
Excell 2003?

All times are GMT +1. The time now is 10:08 PM.