q: dropdown list
 

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

q: dropdown list
 

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

q: dropdown list
 

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