View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike R. Mike R. is offline
external usenet poster
 
Posts: 59
Default Can 2 workbooks share data in Name Fields?

Hi,
I have 2 workbooks that use a common data source which is a worksheet loaded
with name fields for validation lists. When I update some of the data source,
I need to update it in two places... is there a good solution so they can
share the data source with all the name fields? Any thoughts would be awesome!