View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
lulapl
 
Posts: n/a
Default Recalculating Links

I need to use Find and Replace (Excel 2002) to modify a lot of formulas. Is
there a way in VBA to disable the recalculation of each cell after the
formula is updated? It's taking forever!

I tried the follwoing but it does not work:

Sub Macro1()
Application.Calculation = xlManualCalculation
Application.ScreenUpdating = False
Application.AskToUpdateLinks = False

Cells.Replace What:="ALL'!", Replacement:="ATG'!", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Application.ScreenUpdating = True
End Sub

Thanks!