Forum Discussion
AlexOrange
Aug 02, 2021Copper Contributor
Can't edit charts - all options greyed out
Hi - I've recently been upgraded to Office 365. I've got a regular reporting spreadsheet, with charts that need updating. However, I can't edit any of the charts! I can't right click anywhere on th...
- Aug 11, 2021Well I managed to find a solution - I copied all the tabs from my original workbook into a new workbook, and I could then edit the charts. Still don't know what caused the original problem, but putting up this solution for anyone who faces the same issue in future
AlexOrange
Aug 11, 2021Copper Contributor
Well I managed to find a solution - I copied all the tabs from my original workbook into a new workbook, and I could then edit the charts. Still don't know what caused the original problem, but putting up this solution for anyone who faces the same issue in future
- Ranjit_MSOct 18, 2022Copper Contributor
I'm facing the same problem and I'm disappointed no one from Microsoft seems to have unearthed the root cause. Copying large number of sheets and trying to recreate the chart will require too much time and is not an option.