Forum Discussion
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...
- 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
AlexOrange Hi, I recently encountered the same problem. You have to turn off the "shared workbook" option. Once you do, you will be able to use all the functions normally and move around charts.
I know it's a late response but I hope this helps someone else with the same problem later on!
