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:
=OFFSET(Ranges!$A$1,0,0,COUNTA(Ranges!$A:$A),1)
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...