#1
|
|||
|
|||
How do I find Source of Pivot Table
I'm now using Excel, from MS Office Professional Plus 2010. I'm trying to figure out the source of the data on a pivot table I received. Any suggestions?
|
#2
|
||||
|
||||
When you select a cell in the PT a special tab appears on the ribbon called Pivot Table Tools
Click the Options Tab and click "Change data source" You will now see it ( there are probably other ways)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
OK, thank...yes, that works.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2010 cannot find data source | wsdb | Mail Merge | 7 | 09-05-2012 03:16 PM |
Cannot find source of overallocation | nesskramer | Project | 3 | 06-29-2012 08:46 AM |
VBA: Include Dynamic Sheet Name In Pivot Table Source Data | ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |
How do I find the Source folder? | PhilAJ | Mail Merge | 6 | 04-22-2011 05:45 AM |
pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |