Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automaitcally update external defined names?
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.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automaitcally update external defined names?
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 EditLinks and see what the settings are. HTH, JP On Jan 8, 9:39*pm, Chris wrote: 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.... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
automaitcally update external defined names?
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? "JP" wrote: 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 EditLinks and see what the settings are. HTH, JP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why use defined names? | Excel Discussion (Misc queries) | |||
defined names | Excel Worksheet Functions | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
How to make an external link to a filename defined by a cell value | Links and Linking in Excel | |||
Defined names | Excel Discussion (Misc queries) |