I have a pivot table referencing a dynamic named range (DNR) within the workbook (not referencing content in another workbook). When I update the content in the DNR on my local, the pivot table refreshes properly. When I send the file to my customer, the same updating steps result in the pivot table removing all value and columns fields from the pivot table upon refresh. I have confirmed that the DNR is still referencing the same data range on their end. It is not broken. Additionally, the DNR is not referencing an external workbook. It is referencing content within the same workbook.
I am at a loss as to why this problem would arise on a different machine. Both of us are on 2010.
The attached image shows the Field List before (left) and after (right) the refresh on the customer's machine.
I am at a loss as to why this problem would arise on a different machine. Both of us are on 2010.
The attached image shows the Field List before (left) and after (right) the refresh on the customer's machine.
