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

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

https://answers.microsoft.com/en-us/msoffice/forum/all/remove-share-button-from-upper-right-hand-corner/c74d156f-0f8a-4e2a-b039-950026867ab3#:~:text=Finally%2C%20if%20you%20are%20the,button%20on%20the%20OneDrive%20website.

It’s not the most obvious.

Susan Bradley Patch Lady

Reply | Quote

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

Reply | Quote

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.

 

Reply | Quote

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.

https://docs.microsoft.com/en-us/office/troubleshoot/excel/use-shared-workbook

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

Ron M

 

Reply | Quote

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.

Reply | Quote