Excel 2007 can not link to SQL 2000 OLAP

• Andy Howell

  SSC Veteran

  Points: 277

  More actions

  March 10, 2011 at 7:49 am

  #98074

  Hi all,

  I have an excel 2007/2010 spreadsheet that I want to connect to my OLAP in SQL 2000.

  The cube is built and works in older excel when I install the SQL SERVER 2000 PIVOTTABLE SERVICES FOR MICROSOFT SQL SERVER verison 8.

  But this will not install in Excel 2007 (to be accurate, it does install, then has a bad side effect on opening up any old .xls spreadsheets). Does anyone know what I do need to install?

  This may be more Excel than SQL?

  Thanks

  Andy

  PS. The only other machine that has Office 2007 on also has SQL 2005, so it works already sadly.