Specific sheets in a Google Sheets workbook can be shared with the public. Open a workbook, click on File in the menu and select Publish to the web.
The entire document is currently set to be shared. We can select one sheet to share instead of the complete workbook. Click the sheet selector.
I’ll select the pivot table in the workbook.
Click the publish button.
Click OK to confirm that we want to share this sheet.
Copy and paste the link to share the pivot table. This link can be as a link on web pages or a link. In Google Classroom.
Publishing the sheet as a web page allows everyone to view the contents of the sheet but does not allow them to make changes.