Hi,

I don't believe there is an automatic way to do this. However, you could
write a macro to do it or if each sheet linked to a different file then you
could do it with the Update Links command under Edit, Links.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Kash" wrote:

I have another file linked to this and is for all the sheets.. So I need to
update link values only for the active sheet. How can I do that?