Excel Error "tm1xl: Encountered an improper argument"

[Learn_TM1]

Hi Forum,

I created one Excel Sheet, so that user can configure some value in cube with it. From the Excel Sheet, user can set some parameters, then click one TM1 Action Button, which triggers one TI process to enable the configuration in cube.

One strange phenomenon is that, if the user put the mouse cursor in one cell, which has formula DBRW(...), then click the TM1 Action Button, one error message will show up: "tm1xl: Encountered an improper argument". If the mouse cursor is on some other cells, the error message will not show up.

Could some one tell me how to solve this problem?

Best regards,

Chunyan

[Learn_TM1]

For more information here:
TM1 10.2.2
Excel 2010

[Learn_TM1]

Hi all,

For the update of this issue, I did a work around: move the cells with DBRW(...) funtion to other area, and hide them. The cells in visible area for user, points to the cells with DBRW(...), in order to show the correct value to user. Even user's mouse focus on the visible cells, the Action Button will not show the error message again.

Best regards,

Learn_TM1