Excel 2007 & SUBNM: double-click does not open Subset Editor

Post Reply
harrytm1
Regular Participant
Posts: 226
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: IBM Planning Analytics
Version: Latest version
Excel Version: 2003 to 2019

Excel 2007 & SUBNM: double-click does not open Subset Editor

Post by harrytm1 »

Hi all,

My client is using Excel 2007 with TM1 9.4MR1 client. I created a SUBNM formula in a cell. But when I double-clicked it, the subset editor did not appear.

I checked the Excel option and the Edit Direct into Cell option is switch OFF.

Is this a known bug for Excel 2007 or can it simply be solved by closing and reopening Excel again?

Thanks.
Planning Analytics latest version, including Cloud
Post Reply