I have a list in Column A in my Main.xls, I would like to see this list in a
dropdown list in another excel file. If I add one more item to this list all
the excel files should be refreshed. Is this possible? If

The drop down, data valuation list, works within the same sheet rather
than another Excel File.

So I think it's not possible.

To achieve this, i suggest you to put them together or you could use some
hide and protect feature for your spreadsheets.

Leung

"JIM.H." wrote:


I have a list in Column A in my Main.xls, I would like to see this list in a
dropdown list in another excel file. If I add one more item to this list all
the excel files should be refreshed. Is this possible? If

Jim,

Look at the examples and instruction on the following:-

http://www.contextures.com/xlDataVal01.html

"Leung" wrote:

The drop down, data valuation list, works within the same sheet rather
than another Excel File.

So I think it's not possible.

To achieve this, i suggest you to put them together or you could use some
hide and protect feature for your spreadsheets.

Leung

"JIM.H." wrote:


I have a list in Column A in my Main.xls, I would like to see this list in a
dropdown list in another excel file. If I add one more item to this list all
the excel files should be refreshed. Is this possible? If