Pivot Table Layout

T

TimC

Can I copy a Pivot Table layout from one workbook (excel file) to another? My
app cretes a series of xls identical reports and I am having to setup the
layout every time.
 
B

Bill Ridgeway

You should certainly be able to copy and paste the whole pivot table. Just
highlight the top-right cell (which will be something like "Count of. " to
highlight the whole table.

Regards.

Bill Ridgeway
Computer Solutions
 
K

Ken Wright

Also, why not just do it slowly once and get it right, but record a macro
whilst you do it (Make sure to save in your Personal macro Workbook). Then
you can try running the macro in the new workbook next time.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Visio to Excel 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Power Pivot. Yikes. 0
Move Chart with Text 0
Default Pivot Table Setting 0
Connection files and pivot tables 0
Lost my Table of Contents , Appendices and Page numbers ? 2

Top