TM1 9.5.2 Perspectives and Excel 2007

[rfielden]

We have a workbook that has DBR formulas. A macro has been embeded to only recalc (that worksheet only) when a cell on a worksheet is referenced in a formula. When the user enters into a cell that is used in a calculation, the cursor comes back one cell to the left before moving forward (to the
right again) for additional entry. This causes 'serious' performance issues with our users. The TM1 ribbon has been hidden and modified per an IBM note and even though performance improved with the change, we are still faced with the left burp dance on some cells. This doesn't happen if not connected to TM1.

[rkaif]

In the Excel Options there is a setting for Move Selection After Enter. You can set its direction to Left, Right, Up and Down. In Excel 2003 this option is in the Edit tab.

Another thing, instead of using a macro you can also use the Active Button to recalc your sheet

[lotsaram]

also having in-cell edit mode enabled can often screw around with updating DBR/W and SUBNM. Best to make sure this is turned off

Application.MoveAfterReturn = False
Application.EditDirectlyInCell = False