I have a series of workbooks which access another workbook to complete data.

Some of this is done with data validation by creating a name linked to the
external data. The rest is done using VLOOKUP based on the entries cells
filled with data validation. This all used to work well until I changed the
location of the external data file (moved from My Documents to C:\).

I know I need to change the target in the sheets and this worked fine in the
first one, but the second seems to be causing problems.

When I open the workbook, I'm prompted that the sheet contains external data
and asks if I want to update it. Whne I click Yes, a dialog box opens saying
File Not Found and displaying the root directory where the file is.
Can anyone see anything wrong with the formulae below (copied while Test
Equipment List.xls is open)?
Named ranges
='[Test Equipment List.xls]Sheet1'!$E$5:$E$30
='[Test Equipment List.xls]Sheet1'!$A$5:$A$30
Formulae
=IF(A36="","",VLOOKUP(A36,'[Test Equipment
List.xls]Sheet1'!$A$5:$C$30,2,FALSE))
=IF(A36="","",VLOOKUP(A36,'[Test Equipment
List.xls]Sheet1'!$A$5:$C$30,3,FALSE))
='[Test Equipment List.xls]Sheet1'!$G$5

I've used Find to locate all references of Test and these are the only ones
on the sheet.
I've looked through all the named ranges and the only ones referring to an
external workbook are those listed above, all the others refer to a hidden
sheet in the local workbook.

Any suggestions will be very gratefully received.

Ian