XL2000 - Linking Named Ranges

[LPS]

Tom Hutchins helped me tremendously when he suggested I link two workbooks
by using named ranges. Problem now is I don't remember how to do that and I
can't find the reference in "Help".

Could someone please jog my memory as to how to link a named range in one
workbook to another workbook so that it automatically updates when changes
are made? This is very urgent.

Thx,

 

[JLatham]

It's just like linking to a group of cells in another workbook. Easiest way
to set it up initially is to have the other book open and start typing the
linking formula by entering = and perhaps a function in the cell that is to
link to the other book, like:

=SUM(
then just reference the other book and range name like
=SUM(Book1.xls!RangeName)
and it's done. When you close "Book1.xls" the formula will update to
include the path. By having it open, it saves you from having to type it all
in.