automaitcally update external defined names?

[Chris]

hi. i have this master workbook that contains all the defined name ranges and
data, and then i have other worksheets that use the same format/ template,
but all data points to the data in the master workbook... problem is,
whenever i update the master workbook, like when i add a row to it (the
defined name ranges automatically update for the master workbook), but the
other template workbooks' defined names aren't updated... is there a way to
have all the defined names use the one from the master workbook?or at least
update from it?

everytime the master workbook is updated, all other calculations from the
other workbooks becomes wrong since their defined ranges haven't changed, but
the master workbooks names haves changed....

 

[JP]

When you open the destination workbook (the one with the links), it
should update automatically, or prompt you to update.
If it isn't, you may have turned this feature off.

http://support.microsoft.com/kb/826921

Try checking Edit>Links and see what the settings are.


HTH,
JP

 

[Chris]

thanks for this JP, with this knowledge, i'm not so sure now if what i did
was right... when i copied the template worksheet into a new workbook, only
the defined names of that worksheet were copied over.... so what i did then
was to copy all the other defined names into the new workbook, manually... i
was thinking, could this be the problem why the defined name ranges doesn't
update? if so, then how do i go on with it?

 

[Chris]

i was wondering, since all my defined names are in the form of:
name "A"=[source_workbook.xls]worksheet!a1:j70

can i change them into this:
name "A"=[source_workbooks.xls]A

will this work and update everytime i change the source?