LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default View Pivot Table Source data as a Data Table

Hello kind & helpful people,

I am using Excel 2007

I have a pivot table and I want to be able to look at all of the data that
it represents at once.
That is, I want to see the original data table that was used to create the
Pivot Table.

I have located the source data specified in the "PivotTable Tools » Options
» Data » Change Data Source" area of the ribbon.

That value is: '\Documents and Settings\xgraham\My Documents\This
Data\Pivots for Review\Markets\[Updated 2009 Data.xls]Raw Data'!$A$25:$H$11263

However, the user referred to there (xgraham) is not me, has never worked on
this machine, and no longer works for the company.

I believe the data table is saved with the PivotTable as a default - if I
double click the values fields I do get the sheets created with subsets for
that value - where is it stored in the file?

There are no hidden (or very hidden) sheets or columns/rows in the file

I need to add some columns to the original data table and recreate the
PivotTable, but I can't get to the original data set though it must be
somewhere because the Pivot Table functions normally without there being any
live connections.

Any help is greatfully appreciated,
Regards,
KeLee
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I check/verify data in my Data Source for Pivot table? gayleh Excel Worksheet Functions 1 April 16th 08 08:30 PM
View pivot table external data source in Excel 2007 Marc Forget Excel Discussion (Misc queries) 4 January 10th 08 08:05 PM
View Pivot Table Source Data Mistermonday Excel Discussion (Misc queries) 2 October 27th 07 10:53 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM
How do I view Pivot Table source data file and field names? chocolate2346 Excel Discussion (Misc queries) 4 September 14th 05 06:57 PM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"