I have a pivot table that uses employee salary data as the underlying
data.
I want to send around the pivot table to departments to show them some
summarised data, but due the sensitivity on the underlying information
want to ensure they can't get to the data.

I have tried unchecking the "Enable drill to detail" and even deleting
the Data Sheet, however have noticed that if someone goes and checks
the option again they have access to the underlying information.

Anyway to create the pivot once and detach from the underlying data ?