Currently I create 6 reports in one workbook using basically the same data
except the layout will be re-arranged as per the group viewing each report.

Each month, I change a number of columns headings to reflect the current
reporting month... and I need to go into each of the 6 reports and repeat
this (the same heading change over and over).

Is there a way that if I change the heading on the first report it will auto
change in the subsequent reports.

I can't copy and paste as you can't change the pivot report structure.

Thanks, Mary-Lou

Mary Lou - Assuming:
- the columns headings are not part of the pivot report
- the column headings are in the same cells in ALL 6 workbooks

Then you can select all of the workbook tabs (CTRL+click each one) and type
in the changes in 1 workbook...the changes will appear in the same cells of
each workbook you've selected.

"MLK" wrote:

Currently I create 6 reports in one workbook using basically the same data
except the layout will be re-arranged as per the group viewing each report.

Each month, I change a number of columns headings to reflect the current
reporting month... and I need to go into each of the 6 reports and repeat
this (the same heading change over and over).

Is there a way that if I change the heading on the first report it will auto
change in the subsequent reports.

I can't copy and paste as you can't change the pivot report structure.

Thanks, Mary-Lou

Unfortunately the headings I have the issue with are part of the pivot table.

I can easily handle any headings I also do outside the pivot reports as I
have a "base" headings tab that stores the redundant data that changes month
after month and I simple point all the reports to this "base" tab.

However I would like to do something similar (probably not possible) to
actual pivot report headings.

"Chris" wrote:

Mary Lou - Assuming:
- the columns headings are not part of the pivot report
- the column headings are in the same cells in ALL 6 workbooks

Then you can select all of the workbook tabs (CTRL+click each one) and type
in the changes in 1 workbook...the changes will appear in the same cells of
each workbook you've selected.

"MLK" wrote:

Currently I create 6 reports in one workbook using basically the same data
except the layout will be re-arranged as per the group viewing each report.

Each month, I change a number of columns headings to reflect the current
reporting month... and I need to go into each of the 6 reports and repeat
this (the same heading change over and over).

Is there a way that if I change the heading on the first report it will auto
change in the subsequent reports.

I can't copy and paste as you can't change the pivot report structure.

Thanks, Mary-Lou