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