Highlighted uneditable cells in Excel

Post Reply
michalspiczko
Posts: 1
Joined: Fri Sep 27, 2013 12:40 pm
OLAP Product: TM1
Version: 10.1.x
Excel Version: 2010

Highlighted uneditable cells in Excel

Post by michalspiczko »

Hello,

When a cell is uneditable, e.g. when is consolidated, is highlighted on gray (view of cube in the tm1 perspective, see below)
[img=http://s15.postimg.org/hq49jezk7/tm1_view.jpg]

when I export this view to excel I get this:
[img=http://s14.postimg.org/a3hxmie7h/excel.jpg]

Is it possible to get the same result of highlighting in excel? I'd like to get this result:
[img=http://s23.postimg.org/9s0sio22f/excel_goal.jpg]

The main point is to receive (from a worksheet level) the information if a user have a write access to the cell.

Regards,
Mike
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Highlighted uneditable cells in Excel

Post by qml »

This has been discussed before.
Kamil Arendt
Post Reply