I have a worksheet with named lists. I have a second worksheet that has
validation references (=listname) to those lists to create dropdown lists.
This is working fine. I have now distributed this spreadsheet to multiple
I want to now update one or more lists in my master file and re-distribute
the list worksheet and give the users a method to replace the lists worksheet
in their local copy.
What is happening is that when I copy the updated list to the local
worksheet, and delete the original list worksheet, the second worksheet no
longer sees the named lists. The same thing happens if I first delete the
list worksheet and then copy the new list worksheet. The lists are still
correctly visable in the lists worksheet.
How do I get the second worksheet to see the named lists again?