Update linked pivot tables when page changes in main pivot

N

Needing Help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Tables 0
Pivot Table Page Break Refresh Problem 0
Adding to an existing Pivot Table 7
Pivot ungrouping on refresh? 3
Pivot Table criteria 2
Referencing a pivot tables Grand Totals Column 1
Issue with hidden field in Pivot table 1

Top