extra data for pivot table

F

Fawn

Hi I have a pivot table that 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 data.

Is there a way that I can keep the field in the data area if I change Spare1
title to another name on the pivot range?

Any help is appreciated

Thanks
 

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

pivot table 1
Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Counting Text Data 0
Additional columns for Pivot table 0
How do I add extra data to a pivot table? 3
Excel 2007 pivot table using analysis services cube as data source 0
Slicers and Calculated Items in Pivot Table 2

Top