Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How does pivot table still work after deleting DSN? adolf garlic Excel Discussion (Misc queries) 1 April 7th 09 03:36 PM
Pivot Table Help - Work Around Cell Limit? pt_lily Excel Discussion (Misc queries) 0 August 25th 08 04:36 PM
Copy Pivot Table Data and Paste into New File S Sainsbury Excel Programming 1 November 15th 05 01:17 PM
pivot table doesn't work jrh Excel Programming 1 March 2nd 04 02:29 PM
OfficeXP "Cannot open pivot table source file" when refreshing pivot table Luc Alquier Excel Programming 2 December 9th 03 11:11 PM


All times are GMT +1. The time now is 12:26 AM.

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

About Us

"It's about Microsoft Excel"