Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Existing Remote Links message (97 SR2)

    Every time I start my workbook, I get the message, Existing Remote Links will be Terminated.

    How can I find these mysterious 'Remote Links' to remove this message?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Existing Remote Links message (97 SR2)

    Welcome back Drk, both you and Eileen disappeared the middle of November: very suspicious!

    The bad news is that you need to copy everything to a new workbook:

    Before you copy, get rid of all of your formulas by Edit>Replace and replace the = with ZZ=. It's safest to do this one-by-one to make sure that you don't have unwanted links.

    Now copy everything. Again it is safest to do this piece-by-piece: values, then formats and check the new workbook by opening and closing. After copying, don't forget to reestablish your formulas by replacing ZZ= with =.

    Finally, don't forget to copy any code. Hopefully your new workbook will work OK. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Existing Remote Links message (97 SR2)

    Check out Bill Manville's Find and Remove Links addin <A target="_blank" HREF=http://www.accountingadvisors.com/exdownload.shtml>Here</A>.
    Legare Coleman

Posting Permissions

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