Drop Down in TableView not working.

[IBK]

I have an excel template. I had a DataList on a cell coming from another sheet.  I added the name ranges for the TableView as it gets data from SQl.  It used to work but it has stopped working and the DropDown of the list doe not happen. It shows the arrow for the partuclar cell but when you click it does not show the list. 

Thank You,

Indu

[JackLacava]

This sounds like some issue between your excel code and your TableView. You might want to have Support look at it, we can't really help without extensive information (screenshots etc).

[IBK]

Thank You Jack. I have put in a ticket with OneStream. There is no code but a Data-> List from another sheet on that particular cell where I intend the drop down to be in. It also has a name value range as it is being returned by the Spreadsheet BR rule. It was working fine in OneStream but at some point, it stopped working.

[MarkBird]

Table Views don't currently support drop down lists in excel. There are a couple of enhancement requests open to add this feature:

https://community.onestreamsoftware.com/t5/Planning-Analysis/Allow-for-multiple-drop-down-cell-colum...

https://community.onestreamsoftware.com/t5/Platform/Drop-down-list-for-Excel-table-views/idi-p/27437

Mark