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