How do you copy a pivot table into a new file and have it work?
 

Can you copy a pivot table to a new file and have it work?

How do you copy a pivot table into a new file and have it work?
 

Depends...not really sure I understand your question...
Take a look at these links to develop a better understand of Pivot Tables
and perhaps you can answer your own question:
http://www.contextures.com/xlPivot02.html
http://peltiertech.com/Excel/Pivots/pivottables.htm

You can certainly move the 'elements' of your Pivot Table!! That's what
makes a Pivot Table...well...a Pivot Table.

Regards,
Ryan---


--
RyGuy


"Cindy" wrote:

Can you copy a pivot table to a new file and have it work?

How do you copy a pivot table into a new file and have it work
 

Right-click on the sheet tab Move or Copy To Book (you select) Create a
Copy Ok.

Is that what you meant?


Regards,
Ryan--

--
RyGuy


"ryguy7272" wrote:

Depends...not really sure I understand your question...
Take a look at these links to develop a better understand of Pivot Tables
and perhaps you can answer your own question:
http://www.contextures.com/xlPivot02.html
http://peltiertech.com/Excel/Pivots/pivottables.htm

You can certainly move the 'elements' of your Pivot Table!! That's what
makes a Pivot Table...well...a Pivot Table.

Regards,
Ryan---


--
RyGuy


"Cindy" wrote:

Can you copy a pivot table to a new file and have it work?