Pivot Table Source
How can I see the source of a Pivot Table? When I try to edit to determine the source, the Select Sheet is unavailable. I need to verify the source to determine the accuracy of the data, but I did not create it.
Thanks
Best Answer
-
Hi @Andrea Westrich & @Paul Newcome
The Source Sheet will be listed under the "Source" heading in the Pivot App:
So for Paul's example, it looks like his source sheet is called "Sales Outreach Messaging / Call Scripts"
Let me know if you're able to find it, now!
Cheers,
Genevieve
Answers
-
-
Thanks @Paul Newcome. If I am, how do I see what sheet it is?
-
If you go to the main list of pivot sheets, click on the small sheet icon to the right.
-
Thanks @Paul Newcome. When I go there it shows the Config name and the Pivot table name, but not the source sheet.
-
My apologies. I misread your question. I can't seem to find where the source sheet is listed either. Hmm...
@Andrée Starå @Genevieve P @Mike Wilday Does anyone know where to locate the SOURCE SHEET for the data coming into a pivot table??
-
Hi @Andrea Westrich & @Paul Newcome
The Source Sheet will be listed under the "Source" heading in the Pivot App:
So for Paul's example, it looks like his source sheet is called "Sales Outreach Messaging / Call Scripts"
Let me know if you're able to find it, now!
Cheers,
Genevieve
-
Right there in front of me! Thank you so much @Genevieve P!!
-
No problem at all! 🙂
-
Ugh. Better refill the coffee. Haha. Thank you, Genevieve.