View Single Post
 
Old 01-15-2012, 11:07 PM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

You can use a workaround to do this:
create a new sheet, then create a data list linked to Data list workbook.
Link data validation list to this sheet list. You can hide this sheet now, if you want, if the data list workbook is closed, you will have the last values in your hidden sheet. Whenever you open datalist workbook, links will be updated.
Reply With Quote