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 :-)
------------------------------*------------------------------*----------------


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