Can 2 workbooks share data in Name Fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing 2 pivot tables source name per sheet x 15 sheets in Workbook? 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Access Data from Workbook without seeing the workbook open. 1
Data Update Loops between Folders 2
ADO retrieval from close workbook-data type issue 2
Get column name and data type from closed workbook 3
Restrict Choice in Shared WB (drop down alternative)? 0
merge data macro 4

Back
Top