Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2013, 12:42 PM
bobmayo bobmayo is offline How do I find Source of Pivot Table Windows 8 How do I find Source of Pivot Table Office 2010 64bit
Novice
How do I find Source of Pivot Table
 
Join Date: Mar 2013
Posts: 29
bobmayo is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 05-15-2013, 12:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How do I find Source of Pivot Table Windows 7 64bit How do I find Source of Pivot Table Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,506
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 05-16-2013, 12:42 PM
bobmayo bobmayo is offline How do I find Source of Pivot Table Windows 8 How do I find Source of Pivot Table Office 2010 64bit
Novice
How do I find Source of Pivot Table
 
Join Date: Mar 2013
Posts: 29
bobmayo is on a distinguished road
Default

OK, thank...yes, that works.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I find Source of Pivot Table 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
How do I find Source of Pivot Table VBA: Include Dynamic Sheet Name In Pivot Table Source Data ibrahimaa Excel Programming 2 04-28-2012 12:27 AM
How do I find Source of Pivot Table 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft