spread via excel

stingo · Post by **stingo** » Wed Oct 13, 2010 10:26 am

Hi,

I have another issue.

I want to put a spread function in an excel worksheet. I cannot use the the spread menu of the TM1 form because the dimensions on which I want to spread are in point of view and not only in row or column.

I found that there is a TI function called CELLPUTPROPORTIONALSPREAD that can do what I need, the only problem is that,
If I put a value in a consolidate cell, obviously, the TM1 gives me an error and doesn't save the new value, so I have not a base on which to start the TI spread process.

Have you ever met an issue like this? how can I workaround this?

thanks in advance.
Stefano