Bad link. crashes excel when cell touched
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Bad link. crashes excel when cell touched

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have one cell. It is is linked to another sheet in the same workbook. The link is corrupted in some way, as it is returning "old" data. However, when I try to change, delete, or type over the cell, excel freezes and I have to end task intask manager. Any ideas?

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried selecting an adjacent cell and then dragging the cursor over ?
    In the bottom right corner of the activecell there is a small black square. If you hover the mouse over this square it should cahnge to a black cross. Hold down the left mouse button and drag the activecell over the problem cell.
    It should clear the cell reference & hopefully solve your problem.

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Iain: Tried all of that stuff. I am still hanging up. Thanks for the idea though.

    Joe

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

    Default

    Send me the spreadsheet and I'll try opening it in XL2002. It's error recovery is very good and if there's a problem in the spreadsheet, it'll usually fix it. Also, give me your version so I can send it back in the correct format.

    Also, try copying the worksheet into a new workbook and see if it still happens there. Also try Excel in safe mode and see if the problem goes away. To run Excel in safe mode, click on Start | Run and type 'excel /s' (without the quotes) and press OK. If it works, Excel has minor configuration problems.

    Since you get two free support calls with the Office suite, you could call Microsoft Support at 425-635-7056 for assistance also.
    <font size="-1">Mark Henri</font>

    <font size="-2">Microsoft Tier 1 Excel Support Technician</font>

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

    Default

    Hi Mark

    Can i ask, recovery is good in XP, but looses Macros, do you have a fix to this??

    Cheers mate
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Seriously, Mark, this question was posted in April.

    What is you point here?

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

    Default

      
    MOB its JackLand

    Check you PM
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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
  •  

 

 
DMCA.com