Why is chart options greyed out in excel

Project Bonsai. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure. Microsoft Business. Microsoft Enterprise. Browse All Community Hubs.

Turn on suggestions. Answer sourced here. The screenshot shows the general options for working with Excel, independent of any files. If you cannot edit a workbook, check if the workbook structure or the sheets are protected. All boxes are grayed out and look inaccessible, however they are still clickable and any changes made stay. I was punked by Microsoft. I have this a lot, the problem is the show the preview pane where the file is saved. If the preview pane is showing the file, XL thinks its open so will not allow changes from menus.

Click on another file or close the preview pane and it should be OK. Neither the cause of the issue nor the 'simple' correction has been discovered but all is now well. In most cases you just need to unhide the worksheet , which was hidden by someone or due to a misconfiguration. If it was hidden, it will open up a dialog window asking to confirm the unhide action. This was tested here in Excel and Excel I had this issue.

I didn't realize that. I had the same issue, fixed by unchecking the option of share workbook allow changes by more than one user at the same time Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. March 13th 19, PM posted to microsoft. In that case create the chart in the spreadsheet and then right-click the border of the chart and choose Move chart.

Regarding the grayed out items - you are in Group mode because more than one tab is selected. Right-click any sheet tab and choose Ungroup Sheets. July 25th 19, AM posted to microsoft. Smilies are On. Trackbacks are On. Pingbacks are On. Refbacks are On. The time now is AM. Depending on the settings of the sheet protection, you might not be allowed to edit objects. The solution or course : Unprotect the sheet.

The Show All is marked, yet the Insert Pictures and entire line almost is grayed out. Is that possibly by a deliberate setting by the form creator? I am trying to insert my signature — a.