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

JKPieterse's avatar
JKPieterse
Silver Contributor
May 07, 2018
Is the sheet protected by any chance?
  • werkaroberto's avatar
    werkaroberto
    Copper Contributor
    Nov 01, 2018
    JKPieterse wrote:
    Is the sheet protected by any chance?

    no  it is unprotected

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Nov 02, 2018
      IN Excel 2016, the share workbook button has been removed from the ribbon. You can add it to your Quick Access Toolbar temporarily, you may find the button if you select "All commands" from the dropdown.
  • a g's avatar
    a g
    Copper Contributor
    May 07, 2018

    No, it is not protected. Thanks. 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 07, 2018

      If you open your old workbook and Save As it into new one (.xlsx) will it be the same?

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

        I tried that. It's the same. Thanks. 

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      May 07, 2018
      Perhaps the workbook is in shared mode (Review tab)?
      • a g's avatar
        a g
        Copper Contributor
        May 08, 2018

        Yes, it is in "shared" mode. I'm the only user I'm sharing with. I tried to remove myself and Excel wouldn't let me. Instead, it suggested closing the file. I did that, re-opened, and it's the same. How would I make it unshare?

        When I looked in help, all I found was vague video info that co-authoring is better, though it didn't bother to say how specifically it's better or even in what versions of Excel co-authoring is in. I'm using Excel as part of Office 2013, desktop version, not 365 version.  I also didn't find what I was looking for, how to turn off sharing, since I'm the only one using this spreadsheet. 

        Thanks. 

Resources