Page 1 of 1

Excel Formula just read value without xml setting changes

Posted: Thu Aug 22, 2019 5:40 pm
by HighKeys
Hello friends,

as i can read here every formula can write back in the cubes

https://www.ibm.com/support/knowledgece ... rview.html

In some sheets i just need to read the value and dont wanna write back (i have to change the formular to hardvalues cause i send the report out), but in other i want to write back directly in the cube, so i dont want to change my config evertime.

Is there an way that fits my needs?

thanks and BR
High

Re: Excel Formula just read value without xml setting changes

Posted: Thu Aug 22, 2019 11:59 pm
by Wim Gielis
A long shot maybe, but in Perspectives/Architect you can right-click a websheet > Properties > uncheck "Allow Cell Write Back from Web" ? Does this help ? See the 2nd point with item 7 on this page: http://www.wimgielis.com/tm1_cellchange_EN.htm

Re: Excel Formula just read value without xml setting changes

Posted: Fri Aug 23, 2019 10:29 am
by HighKeys
Hello,

Thanks for your input, i will check this option!


Thanks!
BR

Re: Excel Formula just read value without xml setting changes

Posted: Tue Aug 27, 2019 11:17 am
by HighKeys
Hello,

Thanks, the websheet is really nice for that!


BTW if someone searching the same later, if you Disable Events you can write in the cell without writeback :)


BR