+ Reply to Thread
Results 1 to 3 of 3

Can't break link - only one sheet with no data in this file

  1. 05-18-2021, 05:36 PM #1
    hannabi80
    hannabi80 is offline
    Registered User
    Join Date
    05-18-2021
    Location
    Los Angeles, CA
    MS-Off Ver
    16
    Posts
    1

    Can't break link - only one sheet with no data in this file

    Hello, does anyone can help with this excel file? I have deleted every tab in this file to find which tab has the link. The file still has link that I cannot break!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-18-2021, 05:59 PM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,623

    Re: Can't break link - only one sheet with no data in this file

    Look in Formulas | Named Ranges. Several references to ='\\Spe-sp3\DATA\BUDGET\03MRPPlan\Columbia\ults\[03mrp_Cp_macr.xls]Ultimates'!#REF!
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 05-18-2021, 06:01 PM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,623

    Re: Can't break link - only one sheet with no data in this file

    And also: ='C:\BUDGET\1203 Fcst 3Q FY04\Columbia\p&l\[3q_col_p&l.xls]Macros'!#REF!

    Note the #REF! too.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open File / Copy Sheet / Break Links / Save As
    By lofgren in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2020, 04:34 PM
  2. [SOLVED] Unable to break link - No data in file
    By asha3010 in forum Excel General
    Replies: 1
    Last Post: 06-27-2018, 02:46 PM
  3. File Size Increase / Can't Break Link
    By TARR01 in forum Excel General
    Replies: 3
    Last Post: 09-11-2016, 08:36 PM
  4. Split worksheet into separate file and then break external link.
    By lalaarif1 in forum Excel General
    Replies: 2
    Last Post: 09-17-2015, 04:56 AM
  5. How to Break external refference link without converting formula to value within sheet.
    By rajeshturaha in forum Excel General
    Replies: 5
    Last Post: 07-20-2013, 01:49 AM
  6. creating a link to another sheet in the same file
    By Justin Loreth in forum Excel General
    Replies: 2
    Last Post: 02-22-2006, 12:10 PM
  7. [SOLVED] Break a link/formula but keep the data?
    By Task Lead Nicole in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-13-2005, 12:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1