Hi

I have spreadsheet that contains a sheet with a pivot table and linked pivot chart.

When i try to create a copy of the sheet it copies the pivot table but not the chart?

I have been using this workbook for the last 12 months and it has always copied the chart as well but today has stopped doing so.

I sent the workbook to a colleague and when they create a copy of the sheet it also creates a copy of the chart as it should.

Have i changed a setting in Excel without knowing that has created this issue?

Any help appreciated as i have to copy the sheet multiple times.

Thanks
Tim.