Pivot Table Layout

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TimC - 24 Jan 2006 23:15 GMT

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.

Reply to this Message

Bill Ridgeway - 25 Jan 2006 10:01 GMT

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

> 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.

Reply to this Message

Ken Wright - 30 Jan 2006 23:55 GMT

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.

Signature

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

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

> 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.

Reply to this Message

Rate this thread: