 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Pivot Table Source Data
I think I remember being able to take a pivot table view of data and "double-click" on something (like the column headings or the whole sheet) and a new sheet would be created showing all the background data used to form the pivot table. If you know how to do this, could you please describe the steps for doing this? If your pivottable shows a grand total cell (usually in the bottom right corner), try double clicking on that cell. > I think I remember being able to take a pivot table view of data and > "double-click" on something (like the column headings or the whole > sheet) and a new sheet would be created showing all the background > data used to form the pivot table. If you know how to do this, could > you please describe the steps for doing this?  SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.