Pivot Table Template

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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.
 
Back
Top