View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toby Erkson Toby Erkson is offline
external usenet poster
 
Posts: 32
Default 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.