InfoPath Dev

Hi Folks, I publish my Infopath Form onto Sharepoint List with couple of fields from Form onto Sharepoint columns..... Now, my requirement is to generate PivotTable & Pivot chart in Excel Sheet(via Excel Service). I manage to generate charts but can't able to update/refresh updated Sharepoint List changes...... I have Windows Authentication and using Delegation Access Mode and Using "Trusted data connection libraries and embedded" type in Trusted File Location...... Note: I can refresh data When i open excel from Trusted File Location on my machine and click on Refresh. This mean My connection is correct, but I am missing some seetings in MOSS...... Please advice for any more settings...... Thanks, Chintan

Hi Chintan,

I have no idea. This seems more like a SharePoint issue (vs. InfoPath). We have some SharePoint experts in house. I'll see if they have an idea.

You may want to compare your settings with the Office Blog on this subject:  http://blogs.office.com/b/microsoft-excel/archive/2008/03/24/setting-up-excel-services-to-refresh-workbooks-when-opened.aspx

You may also be seeing an issue with authentication and crossing the machine boundary.  If the data source is on a different server, the authentication will fail unless your server environment is configured for Kerberos.  Depending on security requirements, you may configure the data connection to use a specific account credentials with readonly access to allow refresh for all users.

Hi Jim, Thx for reply. My Excel Service and Data Source (Sharepoint List) are on same server. So i configured Delegation Access Method on my server. Thanks Chintan