We have a excel book that we can open via excel web part on sharepoint page.
The excel book has external data connection to SQL Analysis server.
Presently the setting for Allow External Data is set to 'Trusted data connection libraries and embedded'. It shows up mthe excel book tables and the pivot chart and slicer.
Then, I tried to set Allow External Data to None; now also it displays all of the above. So what exactly is purpose of Allow External Data Under Excel Service Application --> External Data?