Page 1 of 1

Express and Excel

Posted: Wed Nov 23, 2011 8:56 am
by Whorty1970
Hi

I've read that Express is not supported with Excel 2010, but is this just a case of it's not supported, or is it really a case of 2010 just won't work with Express.

If it's a mix of 'it partly works', could someone explain which parts work and which down?

Plus, does anyone know when Express will get the TM1 9.5.2 engine?

Cheers, Whorty

Re: Express and Excel

Posted: Wed Nov 23, 2011 1:06 pm
by tomok
Go to the search box and type in "Excel 2010". I found several threads about Excel 2010 and CX.

Re: Express and Excel

Posted: Wed Nov 23, 2011 1:41 pm
by ADW
It is supported however there are a few issues.

1. The install program does not work. to get round this we copy the files in program files manually (back end install)
2. There a 3 main Excel functions when viewing a cube (Slice, Snapshot, and Active form). Clicking active form and then using it in excel will cause excel to crash. The other two work fine.

Other than that it is all as normal. I din't see not having active form as a massive downer!

Re: Express and Excel

Posted: Wed Nov 23, 2011 2:15 pm
by Whorty1970
Thanks ADW - very useful to know that Excel 2010 does work as we are 2010 and as a smaller company full TM1 and Cog BI would be complete overkill !

I did search the site, I wasn't being completely idle, it's just that I couldn't quite work out whether 2010 did work (with some effort) or whether it just didn't work at all.

Re: Express and Excel

Posted: Thu Nov 24, 2011 3:35 am
by rmackenzie
Whorty1970 wrote:... very useful to know that Excel 2010 does work ...
Steady on - this is the official link (for v9.5). It doesn't mention support for Office 2010.
ADW wrote: ... Clicking active form and then using it in excel will cause excel to crash ...
Active forms are extremely useful and key functionality especially if you are going to use the CX version of TM1 Web (I'm not assuming you are, but you maybe).You should ask some serious questions from IBM/ the IBM partner if you are going to buy something that will be seriously hobbled in your environment.