Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find out where data in piviot table comes from
In a public folder in my company is an excel sheet whit an pivot table. I
need to find the data behind it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find out where data in piviot table comes from
Hi
Right click on PTPT Wizardback you will see the source location for the PT. Alternatively, double click on the Grand Total field of the PT, and a new sheet will be created with a copy of the source data from the Pivot Cache. -- Regards Roger Govier "kristall" wrote in message ... In a public folder in my company is an excel sheet whit an pivot table. I need to find the data behind it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort a Piviot table by the Total field in Excel 2002 | Charts and Charting in Excel | |||
How would you show this in a piviot table? | Excel Discussion (Misc queries) | |||
Find data in one table from another. | Excel Worksheet Functions | |||
piviot table | Excel Worksheet Functions | |||
Piviot table help | Excel Discussion (Misc queries) |