LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PivotTable - Client-Server Settings - xl2003 Giff Excel Worksheet Functions 0 February 6th 08 10:02 AM
Refresh and PivotTable with Analysis Services Marco Russo Excel Worksheet Functions 2 August 8th 07 04:20 PM
Office Excel 2007 for SQL Server Analysis Services eysiperez Excel Discussion (Misc queries) 1 November 27th 06 04:50 PM


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"