+ Reply to Thread
Results 1 to 2 of 2

Break Internal Worksheet links in a file

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    270

    Break Internal Worksheet links in a file

    Dear All,

    I have a file in which there are many sheets. (e.g Sheet1, Sheet2, Sheet3).

    In Sheet2, there is data which is linked to Sheet1 and Sheet3. (e.g in Sheet2, A3 = 10 + Sheet1!E10 + Sheet3!E10 ).
    There are many such formulas in Sheet2.


    Is there a macro which will break the link connection and return the value A3 = 10+50+60 (Sheet1!E10, Sheet3!E10).

    Please assist.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Break Internal Worksheet links in a file

    If you want to remove the formula, just copy the data, and Paste Values...the formula in teh cell will be replaced by it's answer
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Excel file won't break links
    By benalt in forum Excel General
    Replies: 37
    Last Post: 07-14-2022, 11:28 AM
  2. Break internal and external links of selected tabs.
    By lalaarif1 in forum Excel General
    Replies: 1
    Last Post: 05-17-2015, 05:47 AM
  3. How to break the internal link of a chart
    By °K. in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-01-2012, 07:37 AM
  4. [SOLVED] Hyperlinks - Move file to local drive, all links break
    By Shawn McGowen in forum Excel General
    Replies: 1
    Last Post: 03-08-2006, 08:52 PM
  5. Internal links
    By Job in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2005, 03:05 PM
  6. Want Excel to break links between worksheets in same file
    By eclectic_kx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2005, 02:06 PM

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