Pivot Table Template

[Guest]

I run a weekly report that needs to include a pivot table. Currently, I
"re-do" the pivot table through the Wizard every week, However, the fields
are always the same, the data is changed week to week. Can I create a
Template, so that I do not have to go through the Pivot Table Wizard every
week & recreate it every time ???

Thanks for any help !!!

Aaron

 

[Roger Govier]

Hi

Create a Dynamic range for your data. For help on this see
http://www.contextures.com/xlNames01.html#Dynamic

Right click on your PT>PT wizard>Back>source> =myTable (or whatever you have
named the range).

Each week, change the range that myTable is pointing at.

 

[Pierre]

Hi

Create a Dynamicrangefor your data. For help on this seehttp://www.contextures.com/xlNames01.html#Dynamic

Right click on your PT>PT wizard>Back>source> =myTable (or whatever you have
named therange).

Each week,changetherangethat myTable is pointing at.

As a follow up, I tried changing the source to acommodate new rows,
but it "undid" all my groupings and formatting. Now" Cannot Group
That Selection".

Ideas?

Pierre

 

[Roger Govier]

Hi Pierre

Send me a copy of the file and I will take a look.
To send direct use
roger at technology4u dot co dot uk
Change the at and dots to the obvious.