Created macros and links between two worksheets no longer work.

[billfinnjr]

I wrote a couple of macros to copy info from a text file to Excel worksheet and to format the sheet properly. Unfortunately When the file was saved it got saved with a .XLSM suffix rather than a ,XLSX. I have another spreadsheet that references the first one in many formulas. Now those formulas do not work correctly. Is there a way to mass edit the .XLSX references to a .XLSM? I tried using find/replace but that would have been to easy. I have 409 formulas to edit and am not looking forward to doing them all manually
Thanks much
Bill

[xlnitwit]

With the workbook with the formulas open, on the Data tab, click the Edit Links button, and then select the original workbook name from the list and change it to point to the new one.