Remove External References in Named Ranges

Tech

New member
Joined
Jan 25, 2017
Messages
23
Reaction score
0
Points
0
Excel Version(s)
2010
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
 
Yes, but only manually in named ranges. Find and replace can be used on spreadsheet cells.
 
Thank you for the reply. I had to go through one at a time and delete each external reference part of the formulas in the Name Manager.

I was hoping for a better way. It's a shame when copying sheets to another workbook that Excel doesn't have the option to keep or discard the external references.

Cheers!
 
Back
Top