View Single Post
  #2   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?

Well, I thought I would answer my own question... I have figured it out.
Yes, they can. You must just name is properly using the Define Name field
and refer to the other workbook.
thanks,
Mike

"Mike R." wrote:

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!