Remove connections for customer facing reports

Hi All

I need to refresh an Excel report that has a PowerPivot Data Model in it and allow this report to be accessible via a group file share for users to play with.

The report contains connections to SQL databases and multiple pivot tables in the Spreadsheets.

I don't want them to be able to refresh the data and have any sensitive connection information.

How do I pragmatically refresh a workbook like this, then remove the connections still allowing people use the data in the workbook? Or is there a better way of doing this?

Thank you

Cat

I agree with CK76, there is no way to remove the connection, or prevent the user from accessing the pivot cache, without breaking the functionality of the pivot tables, they would be effectively read-only and immutable.

What you are asking for is beyond the scope of what Excel can support, you are moving into the realm of needing a real BI solution like Power BI or Tableau.