Forum Discussion

a g's avatar
a g
Copper Contributor
May 06, 2018
Solved

Can't create chart, option grayed out

Using Excel Home and Business 2013 Version 15.0.5023.1000. Just updated it now.  I had this same problem with an old spreadsheet, where suddenly I could no longer add new data to the chart. So creat...
Charts & Visualizing Data
greyed out
  • JKPieterse's avatar
    JKPieterse
    May 08, 2018

    The trick is to uncheck the box, see screen shots.

    Click Share WorkbookUncheck the box and OK

a g's avatar
a g
Copper Contributor
May 08, 2018

Please read my previous reply as to what happened when I tried to unshare it. I tried to unshare from the review tab (apologies that I didn't say specifically how I tried to unshare). What "should" happen isn't helpful if that's not what happens. 

JKPieterse's avatar
JKPieterse
Silver Contributor
May 08, 2018

The trick is to uncheck the box, see screen shots.

Click Share WorkbookUncheck the box and OK

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 09, 2018
    You're welcome. Glad this solved the issue.
  • a g's avatar
    a g
    Copper Contributor
    May 08, 2018

    Thanks for taking the time to make the screen shots. I THOUGHT I'd already tried unchecking that box but at any rate it worked this time. Thanks. 

Resources