software

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.

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

Regards.

Bill Ridgeway
Computer Solutions

quot;TimCquot; gt; wrote in message
...
gt; Can I copy a Pivot Table layout from one workbook (excel file) to another?
gt; My
gt; app cretes a series of xls identical reports and I am having to setup the
gt; layout every time.
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 :-)
------------------------------*------------------------------*----------------quot;TimCquot; gt; wrote in message
...
gt; Can I copy a Pivot Table layout from one workbook (excel file) to another?
gt; My
gt; app cretes a series of xls identical reports and I am having to setup the
gt; layout every time.