View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diane Diane is offline
external usenet poster
 
Posts: 96
Default Drop Down Menu ~ Source from Different Spreadsheet

Can't get the 2 spreadsheets to link. Created "defined name" with reference
to the source spreadsheet. Destination spreadsheet will not allow me to use
the defined name in the validation list reference.