Recalculating Links lulapl 21.11.2005 19:39:01 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!

Re: Recalculating Links Bill Manville <Bill-Manville[ at ]msn.com> 22.11.2005 08:29:43 Opening the source file(s) would make it much faster Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup