I am finally able to update a PivotTable test that resides on a Microsoft Excel worksheet.

The last test I've run on a PC with Windows 7 Professional x64 x64 SS2008 and Excel 2007.

After install the updated Office 2007 Data Connectivity Components http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en I have recreated the PivotTable and test... but this time I checked, as a data source, type "Microsoft Office Data Connection" and not the ODBC 32-bit...

Read the complete thread (italian language) at this link: http://community.ugiss.org/forums/t/2787.aspx

Thanks