Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reverse Engineer Pivot Table
Is there a way to determine the source of individual cell values in a pivot
table? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reverse Engineer Pivot Table
Double-click on the cell. The data that makes up that piece of info will be
dumped into a new spreadsheet. The other method, if you're connected to a data source that's not in the workbook, is to use the Back button on the Pivot Table Wizard, then select Get Data. -- Toby Erkson http://www.bidata.net/ "CurtB" wrote in message ... Is there a way to determine the source of individual cell values in a pivot table? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reverse Engineer Pivot Table
You can get the source of the database that the pivot table uses but not an
individual cell. -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "CurtB" wrote: Is there a way to determine the source of individual cell values in a pivot table? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reverse Engineer Pivot Table
The double-click option produced a lot of output. Now I just need to
evaluate it. The Excel worksheet is rather complex. Thank you for your help. "Toby Erkson" wrote: Double-click on the cell. The data that makes up that piece of info will be dumped into a new spreadsheet. The other method, if you're connected to a data source that's not in the workbook, is to use the Back button on the Pivot Table Wizard, then select Get Data. -- Toby Erkson http://www.bidata.net/ "CurtB" wrote in message ... Is there a way to determine the source of individual cell values in a pivot table? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reverse pivot table-like data | Excel Discussion (Misc queries) | |||
Reverse Pivot-type Data (that's not a pivot table) | Excel Discussion (Misc queries) | |||
Database table (aka Reverse pivot table) | Excel Discussion (Misc queries) | |||
reverse a pivot table | Excel Discussion (Misc queries) | |||
Engineer calculations | Excel Programming |