Forum Discussion
Suddenly don't have access to charts (grayed out)
I have owned MS Office (not 365) for a few years and I had been charting my financial data that I enter into an Excel spreadsheet each week. Now, suddenly, when I try to chart my data, the recommend...
Hello,
1. Click on File and click on Options.
2. On the left side click on “Advanced”.
3. Scroll down to the “Display options for this workbook:”.
4. Locate “For objects, show:”
5. Check “All”.
And click OK
That should bring back the objects including charts.
In addition, ensure that you're not typing anything inside a cell
1. Click on File and click on Options.
2. On the left side click on “Advanced”.
3. Scroll down to the “Display options for this workbook:”.
4. Locate “For objects, show:”
5. Check “All”.
And click OK
That should bring back the objects including charts.
In addition, ensure that you're not typing anything inside a cell
I have tried and retried these steps to make charts available in the Excel Workbook I am using. It is not working. I tried toggling the All to Nothing and then back to All to see if that would help. Tried three times. Still no access to charts. Any suggestions?Abiola1
I noticed the entry above with Richard Weeks and Jalexy about Unprotecting and Protecting the sheet. I tried to unprotect the worksheet and it requires a password. I don't have the password.
paulabbottThat sounds like it's a protected sheet then. You'll need the password. The original author of the file will hopefully have it. Find the file and right click it, then go Properties > Details ... Authors will be one of the fields in there. You can also hopefully see who last saved the file... Hopefully you can track down who in your organisation to email and get a password. Good luck!
RichardWeeks Thank you for this comment and suggestion! When I realized it was protected, I decided to copy the portions i needed to a new excel document. That must have not carried with it the protection because I was able to modify as needed. Thank you for starting me on this solution with your comment!
paulabbottGreat! I was going to suggest copying out the bits you needed. It works for smaller files, but larger worksheets can have so many linked fields from other tabs that it ends up with tons of cells filled with '###'. Glad to have been of assistance 👍
