Update linked pivot tables when page changes in main pivot

Needing Help

Guest

Posts: n/a

9th May 2009

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

« how do I recover a file that has been overwriten | finding and replacing text with a blank »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Link Subforms to Main Form - 2 Linked Combo Boxes in Main Form	=?Utf-8?B?Sm9obiBE?=	Microsoft Access Form Coding	3	4th Feb 2007 03:08 AM
4 tables want 1 main form and subforms to update the tables	=?Utf-8?B?bHBpZXJjZTgxOUBhb2wuY29t?=	Microsoft Access Forms	0	31st Aug 2006 04:20 AM
Appending Records from Linked Tables to the Real Linked Tables	tbl	Microsoft Access Queries	2	22nd Jun 2006 01:42 AM
auto update linked fields in linked tables	=?Utf-8?B?Smhvd2c4?=	Microsoft Access Database Table Design	1	7th Nov 2003 07:08 PM
using linked table manager to update path on linked tables	Nydia	Microsoft Access	4	19th Aug 2003 11:33 PM