Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Simple link return 0 (Environment: Win2000, Office 2000 pro UK - Sp2)

    Simple link - one cell to another in two different sheets.

    All cell formatting has been cleared.

    Standard "normal" style is applied to the dependent cell.

    Target cell contains a value eg. 736.
    Dependent cell returns 0

    I know for sure I've seen this error before in other workbooks. But apparently it is a general error that occur in special cases - Has anyone heard of this before or have any good ideas or suggestions on this.


    Best regards,
    Henrik Ryberg
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Simple link return 0 (Environment: Win2000, Office 2000 pro UK - Sp2)

    Without more details it is hard to give an answer.
    What formula is in the "dependent cell"? Does it reference the correct sheet name?

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Simple link return 0 (Environment: Win2000, Office 2000 pro UK - Sp2)

    User came back to me and told that it had "suddenly" disappeared.

    (Link was between two sheets and references between the cells were as they should be..)

    Thanks for trying anyway.


    ;o) henrik
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

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