i haven't used excel since 98 and am having a few issues getting the advanced
features back fresh in my memory.. and so, i've been trying to work out a
solution for a couple of hours here...

PLEASE HELP!!!

is there a way for excel (2003 on XP) to update the page field dropdown
lists so the individual items aren't duplicated, and there is only data that
is valid for the first page field..(ie: how autofilters work - you click on
one column, and of those is the menu in the next column...)

hope anyone can help..