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

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote