Thread:Weatherman22/@comment-889116-20190303063521/@comment-1514297-20190304131004

The verbatim text was the result of testing a fix suggested to me on the wikia help pages, and I have deleted it with no adverse effect on the wider spreadsheet in the page. That link did take me to a version of my spreadsheet. There is a degree of randomness to the long text string (key) in the URL, if I look in my history there are loads, but going to any of them leads me to the latest version of the spreadsheet. The ending /pubhtml takes me to a version of the spreadsheet with the tabs along the top. The other version, ending in #gid=0, takes me to a version with the tabs along the bottom, and if I am signed into Google, the end of the address changes to /edit#gid=0 and it becomes editable for me.

So, basically for other users, either the "published" version is visible, or the shared (but non-editable) version, depending on the url suffix. I think I must have published the spreadsheet at some point and then got the link from my Google Drive or Sheets page.