SUBNM requires enter after selection

[jed]

What is it that causes a perfectly normally functioning excel TM1 report to suddenly require ENTER after selecting a different element in a SUBNM formula (when it was not required previously)???

I've seen it many times before but I can't remember what causes it...

[lotsaram]

9.4.1 FP2 has a few bugs in how it handles incomplete SUBNM formulas. The issue you describe is usually preceded by a "VBA error 13: Type mismatch" in the tm1p.xla VBA module, this disables TM1 handling the double-click event that fires the subset editor until the code break is reset (usually be performing another action such as a fresh slice or possibly a recalculate would work as well).

[Gregor Koch]

Hi

Might want to give the good old 'Edit directly in cell' option a try.

Cheers

[jed]

HA - had a brain wave and I've cracked it!!!

It must be a bug (not sure if specific to this version - client version I'm on is 9.4 MR1). It is caused when you have a SUBNM formula in a merged cell. Unmerge the cells and SUBNM works normally again. It's a pain though cause frequently you need to merge cells in reports with SUBNM.

Does anyone know if this a bug logged with IBM or is it a "documented feature"?!