automaitcally update external defined names?

  • Thread starter Thread starter Chris
  • Start date Start date
C

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....
 
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?
 
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?
 
Back
Top