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?

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?

Hi,

Here is a quick little routine I wrote for you which basically recalculated
each formula cell in your sheet, if there are lots of formulas which are not
linked and the routine takes too long, we might need to modify to check if
each cell is actually linked to another file. But this may be good enough.

Sub UpdateSheetLinks()
Dim cell As Range
Selection.SpecialCells(xlCellTypeFormulas, 23).Select
For Each cell In Selection
cell = cell.Formula
Next cell
End Sub

--
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?

This is taking too long time..