A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

See Data behind Pivot Table



 
 
Thread Tools Display Modes
  #1  
Old August 24th 07, 04:20 PM posted to microsoft.public.excel.misc
Deadnskinny
external usenet poster
 
Posts: 2
Default See Data behind Pivot Table

I have a source sending me reports in Excel Pivot Tables that I don't really
want. I need the raw data, and I keep getting Pivot Tables. I've been
searching the help files for how to get the Pivot Tables off so I can see the
data behind them, and I'll I'm finding is instructions on how to build a
Pivot Table onto the data. I don't want the Pivot, I just want to see the
data first to see what I'm working with.

Can anyone tell me how to just turn all the fancy Pivoting off? The data's
in there somewhere under all the buttons and drop down boxes, right?

Please help!
Ads
  #2  
Old August 24th 07, 04:52 PM posted to microsoft.public.excel.misc
roadkill
external usenet poster
 
Posts: 173
Default See Data behind Pivot Table

See if this works. In the pivot table click on each pull-down and make sure
that nothing is deselected (i.e. all are set to "All"). Then double click on
the grand total at the bottom right of the pivot table. A new tab should be
created that shows the underlying data that contributes to the grand total
(which should be everything if nothing is deselected).
Will

"Deadnskinny" wrote:

> I have a source sending me reports in Excel Pivot Tables that I don't really
> want. I need the raw data, and I keep getting Pivot Tables. I've been
> searching the help files for how to get the Pivot Tables off so I can see the
> data behind them, and I'll I'm finding is instructions on how to build a
> Pivot Table onto the data. I don't want the Pivot, I just want to see the
> data first to see what I'm working with.
>
> Can anyone tell me how to just turn all the fancy Pivoting off? The data's
> in there somewhere under all the buttons and drop down boxes, right?
>
> Please help!

  #3  
Old August 27th 07, 06:04 PM posted to microsoft.public.excel.misc
Deadnskinny
external usenet poster
 
Posts: 2
Default See Data behind Pivot Table

AHA I knew it was something that easy. Thanks!

"roadkill" wrote:

> See if this works. In the pivot table click on each pull-down and make sure
> that nothing is deselected (i.e. all are set to "All"). Then double click on
> the grand total at the bottom right of the pivot table. A new tab should be
> created that shows the underlying data that contributes to the grand total
> (which should be everything if nothing is deselected).
> Will
>
> "Deadnskinny" wrote:
>
> > I have a source sending me reports in Excel Pivot Tables that I don't really
> > want. I need the raw data, and I keep getting Pivot Tables. I've been
> > searching the help files for how to get the Pivot Tables off so I can see the
> > data behind them, and I'll I'm finding is instructions on how to build a
> > Pivot Table onto the data. I don't want the Pivot, I just want to see the
> > data first to see what I'm working with.
> >
> > Can anyone tell me how to just turn all the fancy Pivoting off? The data's
> > in there somewhere under all the buttons and drop down boxes, right?
> >
> > Please help!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Data Adding contents of two pivot tables and param que Roundy Excel Discussion (Misc queries) 0 July 2nd 07 10:20 PM
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Pivot Table - Use Other Pivot Table as Data Source WCM Excel Discussion (Misc queries) 1 January 25th 07 06:39 PM
How do I sort pivot table data outside a pivot table Michael Excel Worksheet Functions 1 January 4th 07 02:45 PM
Excel Pivot Table Plugin? (crosstab to data table) HoMoon115 Excel Discussion (Misc queries) 0 February 22nd 06 08:20 PM


All times are GMT +1. The time now is 04:05 AM.


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