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
Excel Data validation bug in 9.5.2?
-
- 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?
"the earth is but one country, and mankind its citizens" - Baha'u'llah
-
- 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?
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.