Peruse the Data Validation secions of Debra Dalgleish's Contextures website
and see if they help you identify your problem.

http://www.contextures.com/xlDataVal01.html

Also check the Dynamic Range section of that same site:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"sunderland27" wrote:

i have a drop down box and i find new things that i wish to add. but for
some reason i am unable to change the table and have it update on the excel
spreadsheet the drop down is located. what can i do?