+ Reply to Thread
Results 1 to 4 of 4

Have a sheet link stuck in workbook, how do i remove?

  1. #1
    Registered User
    Join Date
    02-28-2020
    Location
    Michigan, US
    MS-Off Ver
    Excel 97 SR-1
    Posts
    40

    Have a sheet link stuck in workbook, how do i remove?

    Somehow I ended up with this link to ATPVBAEN.XLA in a workbook sheet and I have tried many things to get it
    removed. Can someone tell me how to rid it from the workbook?
    I am using excel 97

    Regards,
    Chuck

    link.jpg

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Have a sheet link stuck in workbook, how do i remove?

    This is the Excel Analysis Toolpack. It suggests that you are using one more functions from that toolpack in your formulas. In older versions of Excel it shows up as a link. You can uninstall the add-in but it will probably break your formulas if you do.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-28-2020
    Location
    Michigan, US
    MS-Off Ver
    Excel 97 SR-1
    Posts
    40

    Re: Have a sheet link stuck in workbook, how do i remove?

    Thanks 6String, I traced it to my use of mround. Prior to my using it I did not have that link in the workbook and once i used it then the link showed up.

    Have to live with it then.

    thanks for your help

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Have a sheet link stuck in workbook, how do i remove?

    MROUND is built into later versions of Excel and will not cause this link. You may find that an upgrade to a current version will give you a lot of new functionality. Software can change a lot in 24 years.

+ 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: 1
    Last Post: 01-23-2019, 11:17 AM
  2. [SOLVED] Remove link to another sheet within the same workbook
    By som3on3_10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-26-2014, 01:18 PM
  3. Replies: 3
    Last Post: 07-20-2014, 04:41 AM
  4. Replies: 0
    Last Post: 01-28-2014, 02:45 PM
  5. Unable to find / remove link to external workbook
    By jpruffle in forum Excel General
    Replies: 3
    Last Post: 08-09-2011, 11:41 AM
  6. Can't remove ghost link in workbook
    By Michael Wise in forum Excel General
    Replies: 1
    Last Post: 05-24-2011, 09:42 AM
  7. Remove link to another workbook
    By George Gee in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-09-2005, 08: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