Need help on how to automactically refresh after user logs in

Need help on how to automactically refresh after user logs in

Hi. I have created a spreadsheet and then shared with a select number of people.

Then, I embedded the shared link for the spreadsheet in my blog. When the other people go to my blog, they can access the spreadsheet privately by logging in using the embedded section. However, they get a continuous loading message and cannot see the sheet shared with them unless the users click refresh. Is there someway I can get around them having to refresh after logging in to view the sheet I shared to them privately? For instance, is there a refresh HTML code that could be added such that it gets executed once users log in?

One other option I noticed is that I can choose to embed under Publish for any zoho sheet. However, if I embed, I am forced to make the sheet public. I want to keep it private thought. So this option does not seem viable either. Unless is there someway to select private when choosing to embedd a sheet under publish?

Please advise on how I can get privately embed sheets into my blog. Thanks.

Dennis