Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Update linked pivot tables when page changes in main pivot

Can anyone help, I have been told that I can get a macro to update my linked
pivot table when I change the Page area of my main pivot but I have not used
macros...

My worksheet is called Monthly Job Sheet.

My first Pivot Table is called Monthly Figures and the Page field is in cell
B1. The second pivot table named Vehicles has its page field in cell AB13 .
In both cases the Page Field is the Job Number.

Can anyone point me in the right direction please?

Thanks
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
Summarize Linked Data with Pivot Tables Dominik Excel Worksheet Functions 0 November 16th 08 10:59 PM
Pivot Tables will not update Jonesy Excel Discussion (Misc queries) 0 July 26th 07 10:02 AM
Relinking Pivot Tables to Main Table ccfcrup Excel Worksheet Functions 1 September 15th 06 01:10 AM
Refreshing Pivot Tables linked to Oracle Datasource [email protected] Excel Discussion (Misc queries) 0 April 25th 06 12:15 AM
Renaming Cells linked to Pivot Tables gsimmons2005 Excel Discussion (Misc queries) 2 September 13th 05 03:51 PM


All times are GMT +1. The time now is 07:34 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"