drop-downs copied in from another book

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??
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,143,705
Messages
5,720,382
Members
422,281
Latest member
jantoooh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top