TM1 Forum

Hi all,

I created an active form. If I shut down and restart the server from which I created the active form, the form no longer works.

I tried F9, Alt-F9, Shift-F9, Rebuild, change all DBRW to DBR, and tried saving the excel document in different formats.

All the formula still remain on the active form, i.e. the SUBNM, TM1RPTROW and the DBR (but only in the first row, no data whatsoever).

Any ideas? Thanks.

Michael Barker wrote:I created an active form. If I shut down and restart the server from which I created the active form, the form no longer works.

Shutting down the server naturally closes all current client sessions. After restarting the TM1 server you need to log on again to the server, without a logon you can't retrieve any data. I don't know why you would expect anything else! By the your description alone that sounds like your problem. If in fact you were sensible enough to log on and you are getting this problem this sometimes happens when an Excel session that was not logged out "stays up" (as in Excel does not get closed) over a time when the TM1 server is restarted. This results in the Perspectives add-in "remembering" value capsules that are no longer valid. You can run the TM1 "M_Clear" macro but normally the easiest way to fix is simply to restart Excel.

Thanks for the reply. I did remember to log back in

I have restarted Excel, restarted my computer. Let me try this "m_Clear" function.