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?