Results 1 to 3 of 3

Thread: Remove External References in Named Ranges

  1. #1
    Acolyte Tech's Avatar
    Join Date
    Jan 2017
    Posts
    20
    Articles
    0
    Excel Version
    2010

    Remove External References in Named Ranges



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,245
    Articles
    0
    Excel Version
    Office 365 Subscription
    Yes, but only manually in named ranges. Find and replace can be used on spreadsheet cells.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Acolyte Tech's Avatar
    Join Date
    Jan 2017
    Posts
    20
    Articles
    0
    Excel Version
    2010
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •