+ Reply to Thread
Results 1 to 4 of 4

Break one link of multiple links within the same cell

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    Orange County, CA
    MS-Off Ver
    Excel 2013
    Posts
    15

    Break one link of multiple links within the same cell

    Hello, I have a workbook that is linked to 8 different other workbooks. There are many cells within the multiple tabs in this workbook that are linked to these 8 various workbooks and I want to break 6 of them while keeping the remaining 2 each each corresponding cell that originally had the 8 (or sometimes it is just 6, etc.).
    so for example:

    Currently have something similar to this in hundreds of cells within one workbook:
    ='[workbook1]sheet1'!AA15+'[workbook2]sheet2'!AA15+'[workbook3]sheet3'!AA15+'[workbook4]sheet4'!AA15+'[workbook5]sheet5'!AA15+'[workbook6]sheet6'!AA15+'[workbook7]sheet7'!AA15+'[workbook8]sheet8'!AA15

    Need to have:
    = 500++'[workbook6]sheet6'!AA15+'[workbook7]sheet7'!AA15+'[workbook8]sheet8'!AA15
    Where 500 equals the value of the 1st 6 workbooks (not always in this order by the way) = '[workbook1]sheet1'!AA15+'[workbook2]sheet2'!AA15+'[workbook3]sheet3'!AA15+'[workbook4]sheet4'!AA15+'[workbook5]sheet5'!AA15+'[workbook6]sheet6'!AA15

    Is there anyway to do this aside from manually going into each individual cell and adjusting it?

    Thanks!
    Kyrsten
    Last edited by kgallo; 08-22-2016 at 04:12 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Break one link of multiple links within the same cell

    Try breaking the links to the files. Go to Data ribbon, click on Edit Links, click on the filename then click Break Link. This will turn all data from the linked file into values.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    04-18-2014
    Location
    Orange County, CA
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Break one link of multiple links within the same cell

    Thank you. The issue with this is that it turns the entire cell to a value while I only want to turn certain links to a value and keep 2 links as links. Any idea how to achieve this?

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Break one link of multiple links within the same cell

    Sorry - that's above my pay grade I'm afraid. Good luck with it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 08-14-2014, 10:58 AM
  2. Completely remove/delete all the external links (Break Links)
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 05:31 AM
  3. Replies: 5
    Last Post: 03-26-2011, 06:34 PM
  4. Links Within Tabs - Break Link In One Tab But Keep In Another
    By SEOT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2008, 03:55 PM
  5. Break cell into multiple lines by line break
    By Chia in forum Excel General
    Replies: 1
    Last Post: 08-20-2006, 01:40 AM
  6. [SOLVED] Can't find Edit, links dialogue box to break the link
    By Angie L. in forum Excel General
    Replies: 1
    Last Post: 10-13-2005, 06:05 PM
  7. [SOLVED] Can't break a link, all links are removed
    By Peter F in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-10-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1