I have 100s of formulas located in 100s of cells in the same active worksheet which contained a link to a workbook that is no longer relevant. By way of example, the referenced link is:

C:\Users\GARRY\Documents\BUSINESS\TEMPLATES\Microsoft Office\Excel\Savings & Retirement\[PERSONAL INCOME EXPENSE CASH FLOW01_2012.xlsx]

in an sample formula as follows:

='C:\Users\GARRY\Documents\BUSINESS\TEMPLATES\Microsoft Office\Excel\Savings & Retirement\[PERSONAL INCOME EXPENSE CASH FLOW01_2012.xlsx]INPUT Detail-Expense'!$L$765

Is it possible to create a macro that contains the appropriate code to automatically amend that portion of all the formulas contained in all the cells to remove this link.

Thanks in advance for your help