Forum Discussion
Solved
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
How can I work out whats wrong in my environment? It's a company machine, so I can't just uninstall and reinstall Excel 😞
First I'd try same file (I mean repaired file form this thread which works on my machine) on another computer in your organization. You may also check on your computer in safe mode (Win+R, excel /safe).
If works, check add-ins installed.
- What did you do to fix the file? That file is just a cut down of a much larger file that I use
I uploaded file into Google Sheets and immediately (i.e. without any changes) download it from here as Excel file.
- Ah - that doesn't work with my larger file as Google Sheets screws up all sorts of other things. I need a solution to the underlying problem with the charts that I can fix in Excel