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

Hi

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

Right click on your PTPT wizardBacksource =myTable (or whatever you have
named the range).

Each week, change the range that myTable is pointing at.
--
Regards
Roger Govier



"Aaron" wrote in message
...
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

On Oct 8, 4:43 pm, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

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

Right click on your PTPT wizardBacksource =myTable (or whatever you have
named therange).

Each week,changetherangethat myTable is pointing at.
--
Regards
Roger Govier


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

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.

--
Regards
Roger Govier



"Pierre" wrote in message
ps.com...
On Oct 8, 4:43 pm, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

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

Right click on your PTPT wizardBacksource =myTable (or whatever you
have
named therange).

Each week,changetherangethat myTable is pointing at.
--
Regards
Roger Govier


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