I inherited a database that I now need to edit. There is a summary tab with a hidden pivot table and an overview graph. The overview pulls from the pivot table. The pivot table pulls from a summary worksheet. I don't know how the person built this pivot table and I'm having trouble editing it. The data is not changing, but the way we are categorizing the data is changing. For example, we're now not counting "pets" but rather "dogs" and "cats."
How do I go about changing the pivot table and changing the info on the summary worksheet so they continue to link? The text needs to be changed because we are re categorizing, but technically it's all the same data.
Clearly I'm a newb at this, so simple help is much appreciated.
TIA.
Bookmarks