Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Recalculating Links
Opening the source file(s) would make it much faster
Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |