Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 287
Default Pivot Table Template

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default Pivot Table Template

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default Pivot Table Template

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default Pivot Table Template

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
Filter lines with Pivot table and non pivot table columns Grover Charts and Charting in Excel 4 September 28th 07 03:16 AM
Filter lines with Pivot table and non Pivot table columns Grover Excel Discussion (Misc queries) 1 September 26th 07 12:48 AM
Filter lines containing pivot table and non pivot table data Grover Excel Worksheet Functions 0 September 24th 07 07:20 PM
Pivot Table & Template Help GKS New Users to Excel 1 April 3rd 06 06:25 AM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"