Picklist problem

Willi · Post by **Willi** » Sat Jul 12, 2014 3:52 pm

Hello,

I have a question about Picklists in TM1 9.5.2 with Excel 2010. I defined a Lookup-Cube where I want to define all my Picklists because they are not used in an active form. They are used in the static area of the Sheet. The picklist works in Cubeviewer:

: Screenshot Cubview; TM1_Cubeview.jpg (30.72 KiB) Viewed 7752 times

But if I reference the Cell i Excel with a DBRW the Dropdown does not appear:

: TM1_Excel.jpg (25.92 KiB) Viewed 7752 times

What am I missing?

Thanks in advannce

Wim Gielis · Post by **Wim Gielis** » Sat Jul 12, 2014 4:33 pm

If you slice that one-cell-view to Excel to get the correct DBRW, what happens?

Willi · Post by **Willi** » Sat Jul 12, 2014 4:38 pm

It's not sliced. I inserted the DBRW manually in an existing Excel.
Oh, in the Moment I pressed SUBMIt I got the question. If I slice it down it works. A hidden Tab is created. But even if I create the Tab manually in my existing Excel and create the Datavalidation it does not work

Wim Gielis · Post by **Wim Gielis** » Sat Jul 12, 2014 4:49 pm

Do you use an Active form instead of a slice?

Willi · Post by **Willi** » Sat Jul 12, 2014 4:50 pm

Yes. The Excel-Sheet contains an active form but the Picklist is used in the static area above the active form

Wim Gielis · Post by **Wim Gielis** » Sat Jul 12, 2014 5:26 pm

As I said, slice (not active form) the cell with the picklist from the Cubeviewer to a new file.
If that works correctly, copy/paste the DBRW formula and the cells it refers to, to your sheet, above the active form.

Willi · Post by **Willi** » Sat Jul 12, 2014 6:21 pm

I tried that, it's not working

Wim Gielis · Post by **Wim Gielis** » Sat Jul 12, 2014 6:34 pm

And DBR instead of DBRW?

Willi · Post by **Willi** » Sat Jul 12, 2014 6:38 pm

No, no change

Willi · Post by **Willi** » Sat Jul 12, 2014 6:54 pm

It semms to be a Problem with the Excel-Cell/Row7Column. I put the DBRW-Formula in another cell and that works. I test a bit more

Wim Gielis · Post by **Wim Gielis** » Sat Jul 12, 2014 8:56 pm

Willi wrote:It semms to be a Problem with the Excel-Cell/Row7Column

What might this be??? A cell, a row, a column, ... ?

Willi · Post by **Willi** » Sat Jul 12, 2014 10:15 pm

I've really no idea what was the issue. I put the DBRW-Formula in another Cell and it works. Beside a border the cell had no formatting.

Wim Gielis · Post by **Wim Gielis** » Sun Jul 13, 2014 9:13 am

You could have pasted a "good" empty cell over that "strange" cell and tried again.

Willi · Post by **Willi** » Tue Jul 15, 2014 7:47 pm

Sorry for the late reply. I Cannot try this. The linr where I originaly tried to place the picklist is now deleted.

But really thx for the help!

TM1 Forum

Picklist problem

Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem

Re: Picklist problem