Named Ranges in external Data Sources

I have a file which uses various data which is stored in a separate
spreadsheet in a different directory. The location of that external
spreadsheet may change. I have two questions: (1) what is the exact syntax
for naming a range in an external spreadsheet (2) are there any clver ways to
ensure that the reference changes automatically if the external file is moved
to a different location.

There are several ways you could be refering to a named range (individual
cell? Multiple cells) in another workbook. Perhaps particulars are what
method you are using.

If a cell link, is the other workbook open or closed?

As to number 2, unless the workbook is opened and relocated by doing a save
as with the referencing workbook opened as well, probably not.

--
Regards,
Tom Ogilvy

"David" <David@discussions.microsoft.com> wrote in message
news:8255D304-972C-4D81-ACEB-3845D45CC00C@microsoft.com...
> I have a file which uses various data which is stored in a separate
> spreadsheet in a different directory. The location of that external
> spreadsheet may change. I have two questions: (1) what is the exact syntax
> for naming a range in an external spreadsheet (2) are there any clver ways
to
> ensure that the reference changes automatically if the external file is
moved
> to a different location.