Oct 02 2022 07:06 AM
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
Oct 02 2022 07:51 AM
SolutionAs far as I know, that is not possible without using VBA code.
Oct 02 2022 08:25 AM
Oct 02 2022 07:51 AM
SolutionAs far as I know, that is not possible without using VBA code.