Hi there.

Do you have both workbooks open at the time you're doing the drop down?

As an aside, and I realise this is a work around, not the exact solution you originally asked for, have you considered using a Query to load the data in to your spreadsheet when it is opened? You can then have another dynamic range in this workbook. Of course, it does bloat your workbook a bit.

Regards, Rob.