Pat from Indy
New Member
- Joined
- Oct 21, 2002
- Messages
- 11
I have a workbook that is used by others during the day on a network. The first sheet of the workbook was created a while back, and so as not to tie up the book while I was working on subsequent sheets I did it on my hard drive in a different book. The problem:
I copied two new sheets from my book into the book on the network. All three sheets have the same data validation drop-down lists that refer to a sheet called "Lists". This "Lists" sheet was created with the first sheet, but as I created the two new sheets I used another "Lists" sheet exactly like the other one. When I copied over the two new sheets, the drop-down boxes no longer work. I tried deleting and redefining the list names and re-entering the data validation lists on the new sheets, but I keep getting a message about an invalid source. Any ideas??
I copied two new sheets from my book into the book on the network. All three sheets have the same data validation drop-down lists that refer to a sheet called "Lists". This "Lists" sheet was created with the first sheet, but as I created the two new sheets I used another "Lists" sheet exactly like the other one. When I copied over the two new sheets, the drop-down boxes no longer work. I tried deleting and redefining the list names and re-entering the data validation lists on the new sheets, but I keep getting a message about an invalid source. Any ideas??