Hi, I have a number (well loads really) of Excel spreadsheets querying SS2000 Analysis Services cubes using the v8 OLE-Db driver.
I have recently migrated the SSAS2000 cubes to a SSAS2005 installation and want to "point" my existing Excel spreadsheets to the new SSAS2005 data source (all dimensions, members, measures etc. are identical to the original SS2000 installation). I can find no function for editing the connection string (I can in Excel 2007 but I only have Office 2003 available).
Aside from the obvious - upgrade to Office 2007, anyone know how to edit the connection string of an Excel spreadsheet?
Thanks.
Duncan