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.