TM1Web call Excel

[wang_chris]

I have an excel file to call TM1 process.

In the excel file, there are 2 sheets. sheet 1 is for control. When user connects the server, sheet 1 automatically lists out the elemens of dimension "organization" that the user has read permission. Then in sheet 2 , the user can select one element from a cell difined by excel list.

All works fine in excel.

But when I try to open the file in TM1web, 2 things go wrong.
1) even I connect to server when logon at TM1Web. The sheet 1 doesn't correctly list the elements. It seems no cooection has been made with the server. But unlike the perspective environment, where I can find a 'connect' button at menu for this excel file opened in TM1 Web.
2) the cell can not show drop-down list.

[img]C:\TM1\PwC_Budgeting\Temp\IMG1.png[/img]

Whether TM1Web support drop-down list of excel?

and how can I have the excel file makes an auto connection with the logon user of TM1Web?


Regards,
Chris

[jim wood]

If you doa search for macros and TM1 Web you'll find very quickly that TM1 Web doesn't support macros or VBA. There things you can do to get some features working (embedding them in the workbook startup) but the lack of support is replaced by action buttons. You might want to check these out. They're pretty well covered in the documentation,

Jim.

[wang_chris]

No VBA and Macro involved here.

I define a cell in sheet 2 with excel data validation by list. so in excel, when you put mouse on the cell, you will find list combo, but when the excel is open in TM1 Web, no list combo is shown.

[tomok]

When you say drop-down list you are actually talking about Data Validation, correct? TM1Web does support that and it should work. What it does not support is connecting to more than one TM1 server. Is the source of the list located on the same server?

[jim wood]

I'm not sure if Combo boxes are supported. (Data validation drop downlists are supported as Tomok said, Combo boxes can be used to run VBA and I'm not sure if VBA is called by them.)

Jim.

[tm1_bloke]

I've been using combo boxes successfully in TM1 and prior to 10.2. both Excel form controls and ActiveX controls should work, not all but combo boxes at least. 10.2. onwards only Excel form control ones are supported.

[wang_chris]

Let me clarify.

Only Data validation drop downlists is used in the excel sheet. There are 2 Data validation drop downlists, one is normal, the other is validated by a name defined in excel.

Both work fine in excel, but when I open the excel sheet in TM1Web, they don't appear as expected.

How can I upload image here?


Regards,
Chris