Hi Jim
All I've got in each of the cell is = Path of the drive/folder/file/cell ref#

Here it is .
='E:\Sales_ Distribution\BRANCH_SALES_&_ACTIVITY_MIS\Daily Activity
Tracking\6. Jun 2009\[Canary_Wharf (PB).xls]DATA_ENTRY'!B19

The above formula is placed in cell B19 of the COPY sheet.

This is what the page look like (on the COPY sheet) when the
update is meant to happen.
Rows 1-16 works fine, the issue starts from Row-17 (sometime this can vary
as well)

Row-15 01-Jun-09 15:37:57 Rob Hamilton Client Meetings
Row-16 01-Jun-09 15:38:21 Rob Hamilton Client Meetings
Row-17 #REF! #REF! #REF! #REF!
Row-18 #REF! #REF! #REF! #REF!
Row-19 #REF! #REF! #REF! #REF!

Trust this helps.

Matt.

"Jim Thomlinson" wrote:

What functions are you using that are returing the REF errors.
Jim Thomlinson