Pivot table Problem

L

lokee

Here is the problem,


If the source field name of pivot table changes how it affects the
pivotfield in the pivot table. What is the setting which allows the user if
source field name changes it should automatically detects which is changed
and should take that field for calculation

E.g.


There is sheet called as Account detail and has a field name "XYZ" and I
create pivot table as PivotTable1 with sheet name "Summary".There is field
called as "Count XYZ" on Summary sheet i.e. in PivotTable1 using XYZ from
Account detail sheet. So if anyone changes the name of XYZ it is affecting
Count XYZ also i.e it showing #Name?

So it must be the problem of linking.
Please help
 

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

Problem if Source field name of pivot table changes 1
Auto Fill Word Documents 4
Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
display all row fields in pivot table 1
Write back from pivot table 1
Write back from pivot table 0
VBA Pivot Table Error 1

Top