extra data for pivot table
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 |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com