Hi,
There doesn't seem to be an obvious way to determine what source data a pivot table is drawing is information from. Can anyone help?
Gratefully,
John Quinn
Hi,
There doesn't seem to be an obvious way to determine what source data a pivot table is drawing is information from. Can anyone help?
Gratefully,
John Quinn
Hello,
to determine what data source a pivot table is using, click any cell in the pivot table. Then, on the Pivot Table Tools ribbon click the "Change Data Source" command. This will highlight the current source for the pivot table.
cheers, teylyn
Teylyn,
Thank you very much. Very helpful!
JQ
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks