Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

Post Reply
Paul Segal
Community Contributor
Posts: 251
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

Post by Paul Segal » Thu Jun 22, 2017 9:28 am

Protecting a sheet in Excel and then unprotecting a cell in the sheet that has a (vanilla) SUBNM formula appears to break the SUBNM formula - I can pick a new element from the set editor, but the cell drop down doesn't appear and the SUBNM cell is not updated with the new element when it's selected from the set editor. Removing the sheet protection restores the functionality. Anyone else seen this or is it just me?

Excel 2013 32-bit, running PAX 2.0.1. Perspectives using the same TM1 server works as expected.
Paul

Paul Segal
Community Contributor
Posts: 251
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

Post by Paul Segal » Tue Jun 27, 2017 11:51 am

For anyone interested this is a bug, and a fix is in the pipeline - PI83093 DROPDOWN ARROW FOR A SUBNM CELL DISAPPEARS WHEN SHEET ISPROTECTED (EVEN IF CELL IS SET TO BE UNLOCKED) - although no date for it yet.
Paul

Post Reply