Hi,
I've got a spread sheet 'MASTER' linked to another worksheet 'COPY' (which
is an
exact mirror of the 'MASTER') with cells linked identically by both row &
column.

For some odd reason, when I open just the COPY (with the MASTER closed)
after 10 rows I've get the value ' #REF! #REF! #REF! ' across all the cells.

BUT when I open the MASTER sheet simultaneously the cells get updated with
the right value in the respective cells.

I'm unable to understand this.
SOMETIMES IT WORKS/UPDATES PRECISELY ** BUT NOT ALL TIMES**

Can someone pls help.

Cheers, Matt