Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem if Source field name of pivot table changes
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem if Source field name of pivot
Hi,
this is the intended behavior. How does Excel know you aren't deleting one column and adding another? Cheers, Shane Devenshire ------------ 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Table - Single Source Field Name | Excel Discussion (Misc queries) | |||
How to add new field in pivot table,which doesn't refer to source | Excel Discussion (Misc queries) | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Pivot Table Row Field Format (OLAP Source) | Excel Discussion (Misc queries) | |||
Field Source Error for Pivot Table | Excel Worksheet Functions |