0

I have a Google Spreadsheet with around a dozen sheets in it. I'd like to publish it to the web, but in a way so that I can give a dozen people each a different URL, each of which takes them each to one of the published sheets within the webpage, but without access to the other sheets. At the moment, I only get a single URL, and there's a navigation bar that lets you switch between sheets, so that doesn't work for my purpose.

Example:

Person A gets a link to the published webpage for sheet A within the spreadsheet, and when they go there, they have no way of getting to the webpage for sheet B, C, D, etc.

Person B gets a link to the published webpage for sheet B within the spreadsheet, and when they go there, they have no way of getting to the webpage for sheet A, C, D, etc.

And so on.

Is this possible out of the box, or with a little jiggering? Thank you!

2
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Sep 21 at 9:06
  • Honestly it seems pretty clearly stated to me, and I can't think of a way to make it clearer. Can you please explain which part you didn't understand?
    – Brionius
    Nov 30 at 0:57
0

By the sound of it, you have tried to publish your spreadsheet and have encountered these problems. Admittedly the documentation slips over this aspect, though a little experimentation reveals the options.

You can "Publish to the Web" as many times as you like.

On the popup (under Link) there is a dropdown where you select which sheet(s) to publish - just select the specific sheet you want to share. Then copy the URL. Do the same for each of the sheets you want to share. Each URL is unique and none will allow a user to see the others sheets.

1
  • Thanks, but unfortunately, this does not fulfill the stated requirements. This yields a URL ending in "&single=true". If the user deletes that part of the URL, they get the same old sheet with tabs where they can see all the other tabs. If there was a way to obscure that, it might be acceptable, but as is, it's much too easy to gain access to the other sheets.
    – Brionius
    Nov 30 at 0:54

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.