Tanner_2004
Well-known Member
- Joined
- Jun 1, 2010
- Messages
- 616
This is the first time this has happened to me. I am using Excel 2010. Before creating my pivot table and charts, I converted my source data into a table. From this table, I created by pivot table and charts.
I checked the Name Manger, Go To functions and I can't find it.
When I use Change Source Data, it identifies Table1, but no when I click on Table1, I get Reference is not valid.
The PTs still have drill-down capabilities when Ii select data from a pivot table. Interestingly, every time select data (a cell) to see the associate records, Excel copies the data to a new worksheet and labels the data, Table1.
Please help me find the underlying data/Table.
Thank you.
I checked the Name Manger, Go To functions and I can't find it.
When I use Change Source Data, it identifies Table1, but no when I click on Table1, I get Reference is not valid.
The PTs still have drill-down capabilities when Ii select data from a pivot table. Interestingly, every time select data (a cell) to see the associate records, Excel copies the data to a new worksheet and labels the data, Table1.
Please help me find the underlying data/Table.
Thank you.