I have a workbook that references various other workbooks on the server.
All the files relate to the current month, so every month we do a
find/replace to update the filenames.

What I would like to do is store the filenames in the workbook and have each
on as a named range.

So instead of the formula =[g:\finance\shared]book1.xls!a2    I can use
=book1!a2

I've tried doing this but each time it opens up the file explorer window and
asks for a file.

Thanks in advance

David