When uploading the Hotsheets to SharePoint notice the following:
If you click on Run All Queries button before uploading the file, the file will show the data in.
If you upload the file before running the query, it will show blank.
If you download the file from SharePoint and click on Enable Editing the PeopleHR tab will show again.
If you open the file on SharePoint, the file will be normal Excel sheet [Without the PeopleHR tab].
If uploaded in the SharePoint, it should be completely fine if sharing the document with specific people, as long as you do not have restrictions applied directly on the file
Ensure that you do the following:
Click on the Share button on top right of your Hotsheets, and select the employees you want to share the file with.
Download the file form SharePoint as it's can't be open on the browser.