The pivot table is not updating in EWA webpart, when we clik on manaull refresh the browser get refreshing but the updated data is not fetching from sharepoin list.
please let me know if i'am missing anything...
below are the steps done :
1. Configured un attended service account, below is the article to configure the account.
2. Set the ApplicationID in the Excel services -> Global settings
Change the connection properties in Excel to None