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

  • Thread starter Thread starter Pluff
  • Start date Start date
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.
 
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
 
Back
Top