TM1 Forum

play around the TM1 in excel lately, found that if a user presses delete button in a cell , it clears the formula and the cell no longer get a value from cube.
is there a way to avoid the formula from being clear out except disable the delete button ?

thats no different to any formula in excel, the only way to stop it is either disabling the delete key (which will annoy your users no end!) or protect the worksheet with a password. i always go with option 2

protect workbook with a password?? but wat if it is a input template .. ...

This is a long standing gripe I have with the TM1 Excel interface. Having been told over 5 years ago by Applix (in fact Manny himself!) that it would not be a problem to separate protection of the dbrw formula and the number being entered nothing has changed and I do not think anything will change given the concentration on the new planning front end. So, options are
- use macros etc to disable backspace, delate, cut keys and functions. This takes a lot of effort and, as Steve points out you, end up so with something that is not really excel. any more.
- have an input area where users can copy delete etc and have a protected DBSW range to send data
- use TM1 web

Hi Iseak,

Assuming "Delete" is disabled, how about choosing "Clear" option from TM1 data spreading methods (by clicking the icon "Clear" from toolbar).

Thanks
Reddy

That would work. Don't forget the shortcut - pressing C on a cell (detailed or summary) will clear everything underneath it, subject to rules and security. Since spreading came in you can't assume that consolidated values can't be updated.

iesak wrote:protect workbook with a password?? but wat if it is a input template .. ...

almost all of mine are input templates. don't forget that each cell has a "format" to determine if its locked or not when protection is enabled. i tend to use blank cells which are not locked for user input, then dbs formula in locked cells to do the send / checking with tm1. that way i protect the formula and the integrity of the sheet while enablign the user to do the normal things like copy and paste data.