Excel Pivot table is not updating from the sharepoint list in MOSS 2010

Question

Hi,

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.

                              http://www.mssharepointtips.com/tip.asp?id=1041

                2.  Set the ApplicationID in the Excel services -> Global settings

           3.      Change the connection properties in Excel to None