Restriction to 256 columns even in Excel 2007?

Post Reply
nicolas.hug
Posts: 2
Joined: Wed Apr 08, 2009 11:34 am
Version: 9.1 SP2
Excel Version: Excel2007

Restriction to 256 columns even in Excel 2007?

Post by nicolas.hug »

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?
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: Restriction to 256 columns even in Excel 2007?

Post by Martin Erlmoser »

do you try it with 9.1 SP2 ?
i thought only 9.4 is "really" 2007 supported?
nicolas.hug
Posts: 2
Joined: Wed Apr 08, 2009 11:34 am
Version: 9.1 SP2
Excel Version: Excel2007

Re: Restriction to 256 columns even in Excel 2007?

Post by nicolas.hug »

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.
Post Reply