MS SQL Server PivotTable Services
 

We have upgraded from SQL 2000 to SQL 2008 and use Analysis Services. Users
have created many spreadsheets to get data from AS2000. There seems to be no
obvious way to convert these spreadsheets to use the Microsoft SQL Server
2008 PivotTable Services connection - the existing spreadsheet does not allow
you to change the connection. I know that the Excel Add-In seems to be
transparent, but is there a workaround to change the connection using pivot
table services? Thanks.