Excel Data validation bug in 9.5.2?

Post Reply
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Excel Data validation bug in 9.5.2?

Post by iansdigby »

Has anyone else seen this issue?

In an Excel sheet, we have a cell with a TM1 DBRW formula and also an Excel custom Data Validation which points to a list on another worksheet.
In TM1 9.5.1 this scenario works fine; in TM1 9.5.2 it returns "TM1 Error". We reproduced this repeatedly so it is systemic.

Ian Digby
"the earth is but one country, and mankind its citizens" - Baha'u'llah
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Excel Data validation bug in 9.5.2?

Post by tomok »

How is the data in the list structured? Hard-coded values or formulas? If formulas, are they TM1 formulas? SUBNM or DBRW? Any inter-referencing going on? I use this very scenario all the time on 9.5.2 so I know it works. You must be doing something a little differently.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply