COnverting Pivot to table

**djmatok** · 08-01-2012, 12:23 PM

HI, Can someone help me to convert a pivot table to a table in Excel 2007

thank you

**Kyle123** · 08-01-2012, 12:42 PM

Can't you just double click on the grandtotal of the values field, this should give you all the data?

**tlafferty** · 08-01-2012, 12:44 PM

The fast way to do this is to click anywhere in the pivot table, then on the options tab, click OLAP tools, convert to formulas. If you are prompted to convert the filters, click yes. If you have to many filters, the conversion won't happen and you'll have to try again without including the filters which will remain in pivot table form. If you aren't familiar with cube formulas, you'll want to check the help topic, as you can extract data directly from the source via cubevalue, cubemember etc.

**djmatok** · 08-01-2012, 02:57 PM

Lafferty,

Actually I do not have access to OLAP tools.

The only disadvantage with double clicking on a number field in the pivot table to get information is that you are obtaining bits and pieces of the data.

Thank you guys!

**tlafferty** · 08-01-2012, 05:07 PM

I see that you are using Excel 2003. It's been quite a while since I played with that version

but I'll give it a shot. In order to get an idea of what each piece of your pivot table is doing, click a cell outside of it, press the equals key on your keyboard, then click the cell containing the total.

Here's a link to a quick overview:
http://www.techonthenet.com/excel/pi...pivotdata2.php