SOLVED

First item drop down list doesn't update

Copper Contributor

Hi Everyone!

 

I have a problem with the update of the first element of the drop down list.

Tried everything I know but without success.

 

I have a drop down list in worksheet A. It bases on drop down list in worksheet B.

When I update drop list in worksheet B my drop list in worksheet A seems to be not updated.

it shows previous choosen element. But when I click it than it shows new elements.

 

Does anybody know how to make also the first element show first element from the new choosen list?

 

I was trying with name manager and direct formula  in the data validation drop down list. Nothing helped. I was trying to retrieve new list with indirect formulas and index, match formulas. The data retrieved are fine but the case is the first new element from the list that doesnt shows up on the drop down default. untril I click and choose new one from the list.

 

I know that is possible to refresh by macro. But I would like if this is possible to not to update it with the macro. Security limitations.

 

please help

thank you.

Maciek

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2 Replies
best response confirmed by macmac (Copper Contributor)
Solution

@macmac 

As far as I know, that is not possible without using VBA code.

@Hans Vogelaar, thanks for prompt reply. That is what i thought so....
1 best response

Accepted Solutions
best response confirmed by macmac (Copper Contributor)
Solution

@macmac 

As far as I know, that is not possible without using VBA code.

View solution in original post