Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Pivot Table & Template Help | New Users to Excel |