Drop Down list doesn't update itself rightaways

[questionguy]

I have a Named Range which I am using for my drop down list which three items: Received Damaged, Not Enough Material, Damaged in House. The code is as follows:

Please Login or Register  to view this content.

My goal is to automatically update my drop down list as soon as I add a new item.

However, it only works when I reopen my workbook. Anybody know the cause? I want it to appear instantly...

[TMS]

Sounds as though you have calculation set to manual.

Out of interest, I prefer to use INDEX rather than OFFSET: =Ranges!$A$1:INDEX(Ranges!$A:$A,COUNTA(Ranges!$A:$A))


Regards, TMS

[questionguy]

Thanks a lot...