I have a public facing SharePoint 2010 Enterprise website with anonymous access enabled. I'd like to present information (a pivot chart) from an .xslx file using the Excel Viewer Web Part.
It works fine when I place the .xslx file in a document library that the anonymous users can access.
I would, however, like to remove anonymous access from the .xslx file and only expose the chart from the .xslx file using the Excel Viewer web part. When I alter the library permissions to remove anonymous access to the library that holds the .xslx file,
the Excel Viewer web part displays an "Access Denied" message to the anonymous user.
Is there some other way to achieve this?
View Complete Post