Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Linking doesn't work (XP)

    Iím in a state of panic. Some linking in my spreadsheet doesnít work.

    I've finished a spreadsheet for a client and I have a hand-over very shortly. (hence the reason for the panic)

    On one of the sheets I have all information collected in neat rows and columns which I use for VLOOKUP purposes. These cells are populated by either linked info which is entered Ė such as a date - and to info which are dropdowns. Neither of them update.

    Iíve checked if the calcs were automatic and they are, Iíve hit F9.. Nothing.

    All sheets are protected, apart from the cells that need filling out and updating. The linking is more or less to unprotected cells.

    When I re-did the linking, it worked, but it should work automatically. Because I can't expect myclient to re-do the linking everytime a change is made.

    Any suggestions ???

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking doesn't work (XP)

    Does the problem persist after rebooting your PC?

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Linking doesn't work (XP)

    Nope I will try and reduce the workbook and post it here..
    its huge so it will take some time

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Linking doesn't work (XP)

    Robooting didn't do it, however, renaming did.
    I saved the file as "Example for Woody" and bingo !!!! its working again

    Thanks for suggestion rebooting what a relieve

    Cheers

Posting Permissions

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