Pivot Table Layout
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. |
Pivot Table Layout
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. |
Pivot Table Layout
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. |
All times are GMT +1. The time now is 07:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com