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:
=SUBNM("tm1server:FIN_Fisc_Entiteit";"";"FE051";"NL")
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
Application.Run "TM1RECALC1"
with:
Me.Calculate
(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?
Thanks heaps,
Wim