In the Excel client the connection is not made until the "enable data connections" security warning is clicked. This allows the user to view all the data in the file. Once the connection is made by allowing data connections, they can only see the data they have access to.
2. Publish a version of the workbook that does not show all of the data. This forces the user to make a page filter selection after the workbook is rendered and they can only choose the data they have access to.
Another recommendation would be to upgrade to SharePoint 2013 which allows users to edit the Pivottable in the browser. This will eliminate the need to open the workbook in the client.
Id. de artículo: 2799448 - Última revisión: 13 feb. 2013 - Revisión: 1