TM1 Forum

Hi All,

How do I stop TM1 automatically uploading data from an input template? Everytime I open an old template while connceted to TM1, it automaticvally uploads the data even with my excel settings on manual. I want to control it by hitting a data submit button.

Please advise.

You could use IF functions to check if a certain fixed cell is Y or N, 1 or 0, whatever.

The IF then will have the send formula in the True part, the False part can be customized as well if you like.

Note that the file will not be smaller/faster after you add all the IF's ... (and that's an understatement)

Wim

If it's executing when you open the template up, there's probably some vba statements that execute automatically. You want to disable some of these statements since that code will execute before you'll get to a test cell unless that test is also embedded in the auto-open code. Do a google on "auto run excel on opening" since there are a few different ways to access the code depending on the version of excel you're using.

dymoy wrote:If it's executing when you open the template up, there's probably some vba statements that execute automatically. You want to disable some of these statements since that code will execute before you'll get to a test cell unless that test is also embedded in the auto-open code. Do a google on "auto run excel on opening" since there are a few different ways to access the code depending on the version of excel you're using.

Alt-F11 to get to the VBE.

Then, in the Project Explorer, search for your file. Expand the nodes below the name.

Within that file, either in the Workbook_Open event in ThisWorkbook, either in a separate module as an Auto Open procedure. In the latter case, and with many modules in the file, searching with Ctrl-F is much easier.

Wim