Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

Post Reply
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

Post by Paul Segal »

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: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

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

Post by Paul Segal »

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