I need a way to show only the pivot tables, reports, etc when I publish to my web page.  Right now all the tabs/sheets can be seen including the raw data.

Is there a solution for this?

Can I have one spreadsheet file with the raw data and link to another to create the pivot tables, reports, etc for publishing?

Thanks for the help.