Log In
Register
Home
New Member
July 26, 2024
Offline
Hi!
I am using your awesome project management dashboard spreadsheet! I am trying to rename a pivot table from "manager" to "staff." I was able to easily rename the column headers in the Dashboard and Data Tabs by clicking on them, but then when I hit refresh, they disappeared. I think I need to rename the source data, but I can't find it. How do I find the source and rename? (I tried to include a screenshot, but it didn't work.)
Thanks!
Inga
Moderators
January 31, 2022
Offline
As I understand, you renamed column headers in a table that sources a pivot table. Correct?
Let's say one pivot table (pt) uses the Manager column for the Row headers. And you have renamed that column to Staff in the source table, then Excel indeed does not find the Manager column and removes it from the pt. You need to put the Staff column in the place where the Manager column originally resided.
Does that fix the issue? If not, perhaps you can upload your file here. Remove any confidential information though.
1 Guest(s)
