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
Bookmarks