How do I export multiple lines of data from a pivot table?

P

Pluff

I am trying to use pivot table data outside of the table and I when I drag
the info from one line to the next, the pivot table information stays
constant. I would like it to pull from B2 to B3 to B4 and so on instead of
b2 to b2 to b2.
 
A

Ashish Mathur

Hi,

In Excel 2003, on the Pivot table toolbar, go to Toolbar options > Add or
Remove buttons > Pivot table and select Generate Getpivotdata. This button
will now appear on the Toolbar. When you click on it, it will turn off
formula generation.

In Excel 2007, this option is found in Excel Options > Formulas

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top