We experience a strange bug after upgrading a customer from 9.4.1 to 9.5.2.
To reproduce the behavior: In a new workbook, in cell A1, we have a simple SUBNM formula:
There is a Worksheet_Change event linked to that cell:
Code: Select all
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Range("A1"), Target) Is Nothing Then Application.Run "TM1RECALC1" End If End Sub
If I replace
(hence the normal Excel recalculation), it works well.
The Excel version used is 2010, I have tested on Excel 2003 with TM1 client 9.5.2 and that seems to work as expected.
Anyone seen this before, can explain it or acknowledge it's a bug?