Range('thisIsMyTargetRange').FormulaR1C1 = Range('A1').FormulaR1C1īoth methods are equally slow, and as I said I've checked both of the above methods with the source file opened and closed.

I tried accomplish the linking in two ways (please note this is not a real code, but I hope it shows what I mean):Ĭopy the formula link to the external source from Range('A1') usingĬell.FormulaR1C1 = Range('A1').FormulaR1C1Ĭopy the formula from Range('A1') to another range without using a foreach loop: I have, however, noticed that creating links manually (e.g., by copying and pasting the formula containing the link into other cells by hand) is much faster while the source file is opened.Īpplication.Calculation to be Manual instead of Automatic. There is no difference in speed whether the source file is opened or closed. Now your hyperlinks should be deleted as you can see by the example below: If you need to remove hyperlinks from other sheets, just repeat the steps above. Highlight the macro called 'RemoveHyperlinks' and click on the Run button. It takes approx 1 sec to create a link for 1 cell, but I have several hundred cells to link so it's painfully slow. Under the Tools menu, select Macro > Macros. My Excel application creates links to other Excel files.

Disable links in excel 2003 spreadsheet