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

"TimC" wrote in message
...
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.