The spreadsheet was already set to public (no sign in required) – just like the other “smaller” entries that I’ve created (read my first post) “I’ve tried copied small number of entries in a new sheet and was able to display them.” I have done exactly the same to both spreadsheet only that the smaller spreadsheet (ard 5 rows that I’ve tested) is displayed on the page, but not the 1mb spreadsheet – ard 9800 entries). So the first place was “public” as mentioned in my first post.
Obviously there are reasons why correct link were not provided and post is private in the first place. One can only provide as much details as they could based on the sensitivity of the data. No need to be making fun of user comments and being unhelpful.
I have provided the codes that I was using and an image, so why don’t you provide those “reasons” you mentioned and the possible fixes to that and see if I could apply them to my site, instead of responding with a generic message?
