![]() |
|
#1
|
|||
|
|||
|
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)
__________________
Using O365 v2503 - 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 |