Hi,

I copied 2 worksheets to another workbook. Now in many of the named range formulas exist referencing the other workbook:

[Money Manager 10.1.xlsm]


=OFFSET('[Money Manager 10.1.xlsm]Mortgage Calculator'!$B$34,2,0,nper,1)



Can all of these be removed from the named ranges?

Thank you