Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table
Hi
I have a database that I use for a pivot table. I have named a few extra columns as spare1 spare2 etc. These will be used for future categories in which we may want to use for data. I have dragged these over to the pivot table however when I change the name on the master sheet where the pivot range is defined the data field originally called spare1 (now called "training extras") dragged over to the data field is removed from the pivot table data area. Is there a way that I can keep that field in the data area when I change the name from Spare1 to another name? Any help is appreciated Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table
Hi
Unfortunately not. As soon as the PT is refreshed, then the new Name for the field is read. As the PT has no knowledge of this field, it has to be left on the excluded list, until you decide where it is to be allocated. -- Regards Roger Govier "Fawn" wrote in message ... Hi I have a database that I use for a pivot table. I have named a few extra columns as spare1 spare2 etc. These will be used for future categories in which we may want to use for data. I have dragged these over to the pivot table however when I change the name on the master sheet where the pivot range is defined the data field originally called spare1 (now called "training extras") dragged over to the data field is removed from the pivot table data area. Is there a way that I can keep that field in the data area when I change the name from Spare1 to another name? Any help is appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |