Aug 01 2021 05:20 PM
Aug 01 2021 05:20 PM
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 the sheets containing the charts, and all the options on the 'Chart Design' and 'Format' ribbon tabs are greyed out.
The spreadsheet isn't protected, and I don't think its shared with anyone.
Aug 02 2021 07:15 AM
Please read the information in this link (at the end) and include this information in your request.
In this way you could get a solution proposal much faster and more precisely and it saves the helpers time, with which they can answer more questions. Win-win for everyone.
Thank you for your understanding and patience
Wish you a nice day.
I know I don't know anything (Socrates)
Aug 02 2021 04:59 PM
I'm running PC Windows 10, Version 1909 (OS Build 18363.1679)
I'm using 'Microsoft 365 Apps for Enterprise' Version 2009 (Build 13231.20390 Click-to-Run)
Cut down file is attached
I want to update the charts on sheet 'Weekly giving semi-annual' and 'Income comparisons quarterly' to extend the series show.
However, I can't edit any of the charts! I can't right click anywhere on the sheets containing the charts, and all the options on the 'Chart Design' and 'Format' ribbon tabs are greyed out.
Aug 04 2021 09:10 AM
Aug 05 2021 04:31 PM
Aug 06 2021 02:47 AM
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.
Aug 08 2021 06:05 PM
Aug 09 2021 04:59 PM
Aug 11 2021 12:19 AMSolution
Oct 18 2022 06:54 AM
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.
Feb 13 2023 06:47 PM - edited Feb 13 2023 06:48 PM
@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!