TM1 Forum

Posted: **Wed Apr 08, 2009 11:38 am**

I have an excel sheet where I need to fill more than 256 columns. Fotunately, with Excel2007 this is not an issue anymore

But unfortunately, after Columnt 256 (=IV), I only get *KEY_ERR.
No matter whether I Use DBRW or DBSS or any other TM1 formula.

Is anyone aware about restriction in columns that TM1 can handle?

Posted: **Wed Apr 08, 2009 12:50 pm**

do you try it with 9.1 SP2 ?
i thought only 9.4 is "really" 2007 supported?

Posted: **Wed Apr 08, 2009 1:41 pm**

Seems very much like it. Yes it is a 9.1 SP2.

I just tested it on a 9.4 - and there it works fine... too bad for me.

Thanks for the hint.

TM1 Forum

Restriction to 256 columns even in Excel 2007?

Restriction to 256 columns even in Excel 2007?

Re: Restriction to 256 columns even in Excel 2007?

Re: Restriction to 256 columns even in Excel 2007?