Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
patemarie
 
Posts: n/a
Default Pivot Table Data Refresh

Can something be done to automate a refresh to Cube data in a pivot table in
Excell 2003?
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I am having problems creating pivot table of data wyman Charts and Charting in Excel 1 January 12th 05 05:17 PM
Using Microsoft Query data in a pivot table. slapana Charts and Charting in Excel 0 January 11th 05 05:03 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 01:01 AM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"