Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: links...

  1. #11
    New Member
    Join Date
    Feb 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, maybe I overstated my knowledge about Edit/Links...
    no prob pointing links to my desktop file,
    and even specifying the worksheet,
    but how do i point to its cell A1 which contains "delete me"???

    (is the burning folder a very BAD thing???)

    [ This Message was edited by: laurajean100 on 2002-02-18 14:43 ]

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Laura

    For waht its worth Chris D is on the money correct follow him, i chat to Chris a few times on email hes been on about links ever since i have klnow him, his A1 delete me trick works.

    I tend to highlight (show) all the links / formulas and have a look manually and hunt the terror down.

    I fine that Vlooks are a colprit as the dont update if you arcvive a months finance details and the Vlookup was linked to data sheet all goes horribly wrong.

    I have MASSIVE sheets will billions of fromulas and cells of data and i know the woorkbooks inside out back wards and standing on my head wareing a blind fold playing the drumbs and srtrumming the violin! but all sheets need and require careful daily maintance so you / i the opperator should know the where what at a snap..

    Edit and links will shows all linked data so can edit or remove or whatever....

    Would be my other suggestion -

    Hot tip ---- i have a sheet called test which i have many bizzar formula VBA codes and so on all tests so why not assign a reange to house links data and protect them cells just in cae you delete them them you have record ao all links and where they are should you need to refer to them

    In Test sheet i have hundreda of formulas i have written so i can reuse them,,, all VBA i have also i sheet VBA so i can add them as needs be...

    So thought

    HTH
    Rdgs
    ==========
    Jack

  3. #13
    New Member
    Join Date
    Feb 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I believe, I believe!

    no prob pointing links to my desktop file,
    and even specifying the worksheet,
    ***but HOW do i point to its cell A1 which contains "delete me"???


    [ This Message was edited by: laurajean100 on 2002-02-18 19:47 ]

  4. #14
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    laurajean100
    the trick is to leave the 'links.xls' workbook with Sheet1A1 (or whatever the cell is that says 'delete me') selected. then when you go to change source from your current source to links.xls it will automatically link to Sheet1A1.
    anno

  5. #15
    Guest

    Default

    btw (anno again but a frivolous post so i don't want it to count) the flames are a good thing, if attracting attention is your bag - it just means > 10 posts since you last looked or something like that - this post has i think attracted the largest numbers of views and among the highest number of posts.

  6. #16
    Guest

    Default

    I've been trying to delete phantom links and succeeded in one case using the tips I've seen in this thread. I have another case that's a little tougher.

    I moved each worksheet from a workbook with phantom links to a new workbook. Then I looked at each new workbook to see which one had the link. They all did.

    I started working with one and deleted two charts, thinking that the phantom links were wrapped up in the charts somehow. The phantom links remained. I then deleted all data and formulas from the worksheet. I am left with a completely empty worksheet; no data, no formulas, no special formatting, nothing. The phantom links remain.

    Phantom is a pretty good work for them, I guess. What can a person try after dumping out everything in the spreadsheet?

  7. #17
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    anonymous
    have you checked for named ranges with an external reference? even if there's no data on the sheet the range will still exist. go to insert>name>define and see if there are any there - the 'refers to' box will indicate whether it's external. other than that, have you tried the microsoft fix? it's at http://support.microsoft.com/default...;en-us;Q188449

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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