pivot table

F

Fawn

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
 
R

Roger Govier

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Pivot table multiple filters 2
Expand and collapse 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table Question 2
Help list box to update pivot table 1
Excel 2010 Pivot Table 2
pivot table not getting updated 2

Top