• All my Spreadsheets seemed to have SHARE turned on, how do I turn it off?

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » All my Spreadsheets seemed to have SHARE turned on, how do I turn it off?

    • This topic has 6 replies, 4 voices, and was last updated 1 year ago.

    I am using Windows 10 and Office 365.

    Much to my chagrin, I have discovered that all of my spreadsheets seem to have SHARE turned on.  All of the ones I have looked at seem to have a little green box that says <SHARE> on each one.  My question is, What does this mean?  I am interpreting this as meaning that some feature is turned on that will allow sharing of this spreadsheet with others.  If that is the case, then I would like to turn that off – universally, if that is possible, as I am unclear how it was turned on in the first place. Even new spreadsheets that I open show this <SHARE> button as green.

    Any insight that anyone can provide will be greatly appreciated.  Thanks.

    Ron M

    Viewing 4 reply threads
    • #2447791

      I hadn’t really noticed this button before, but it would appear that it can’t be removed. However, the button merely allows you to share the file with someone – until you do this it isn’t shared. If you do share it and wish to remove the share, just click on the review section of the ribbon and click unshare workbook.

      Eliminate spare time: start programming PowerShell

    • #2447823

      Susan Bradley Patch Lady

      • #2447879

        I saw that one Susan, but doesn’t it only work if you have W10 Pro? The OP doesn’t say he has, and I don’t have it on this PC (only home), but I can see it on my secondary PC with W10 Pro.

        Eliminate spare time: start programming PowerShell

    • #2447882

      access-mdb, I am running Windows 10 Pro on my machine, however I had never noticed the <Share> button  until a few days ago.  My wife has “normal” Windows 10 on her machine, so I will check tomorrow and see if she has the <Share> button.


    • #2447884

      Susan, I checked the URL reference that you posted.  Thank you for that.  It will take me a while to figure out what they are doing.

      I am coming to the conclusion that access-imdb points out in his first posting.  It probably is a relatively benign button unless I want to share a file with someone, so I will probably just ignore it as being another of those added features that Microsoft provides without a lot of documentation.  I would note that the <Help> facility in Excel does describe how to use the <Share> feature as it also uses <OneDrive>. Susan, your posting got me wondering, so I checked the web.  It would appear that there are ways to share documents in Excel going back to versions 2002, 2003, 2007 and 2016 as wells as 365.


      So now we know. My thanks to both of you for the insight. 😊

      Ron M


    • #2448168

      If  sign-out of  your Microsoft Account in Excel the share button is grayed out.  While guarantees you’re not sharing, it will also mean other Office 365 features won’t work such as advanced grammar and spell checking in Word and more template choices for all the 365 apps.  I stay signed out of all my Office 365 app unless I want to explorer a feature that’s not available otherwise.

    Viewing 4 reply threads
    Reply To: All my Spreadsheets seemed to have SHARE turned on, how do I turn it off?

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: