7

For every one of my Google Spreadsheets, the sharing settings is on "Specific people can access" and each sheet is shared with three people I know. Their names are listed when I click on the blue "Share" button.

But if I hover over the blue "Share" button, it says "Shared with xxx people" and that xxx is always greater than 3, looks like between 10 and 90.

What is up with that - is everybody experiencing the same thing?


Edit: It seems like every time you use the IMPORTRANGE function and link data from that sheet the "shared" number goes up. If that is the case, it’s a very different definition of "shared" than what is usually thought of.

4
  • @pnuts. I think it is the answer, but not sure. I didn't want to presume anything.
    – jason
    Jul 11, 2014 at 5:26
  • No repro here. Do you still see this?
    – ale
    Jun 12, 2015 at 1:04
  • looks like google fixed this... i only see 6 people now in that sheet
    – jason
    Jun 12, 2015 at 2:35
  • Since this is a web application this could be the UI displaying incorrect info. I recommend completely clearing the cache & cookies on your browser, making sure the browser is up to date, and seeing if the same info is displayed in other browsers (Safari, Chrome, IE, Firefox). If you are using Chrome, I also recommend testing in an incognito window as this disables extensions & apps as possible causes. Add your results as an edit to your question. Thanks! Oh, thought of 1 more thing: Does anyone else that has the same file shared with them also see the same number of "shared with" people?
    – Folk
    Jul 6, 2016 at 15:24

1 Answer 1

1

No - I just checked a couple of mine, and the count is ok. Both ones that are shared with specfic people (one with 1, one with 3)

4
  • so what could be the explanation of why I have more than the number of people shared?
    – jason
    Jun 9, 2014 at 10:11
  • A bug which was introduced by Google and then removed quickly? Is it still happening for you ? Is there anything special about the three people you've shared with? Jun 9, 2014 at 11:31
  • It's still like that for me. Nothing has changed. Nothing special about these people that share the spreadsheet with me.
    – jason
    Jun 9, 2014 at 12:04
  • fyi, the sheets I tested it on would not have used the IMPORTRANGE function - this would be consistent with me not reproducing the issue. (As you say, it's an unusual definition of "shared" - it's more a count of uses of the data, rather than shares of the file.) Dec 29, 2017 at 21:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.