Linking between workbooks and getting #REF error
 

I am trying to link several excel files into a consolidated excel file. I
already linked 3 files to the consolidated, but when I attempt to link the
4th, I am getting a #REF error.

Here is what I am doing:

I am highlighting the array I want to link from the individual file to the
consolidated file. I copy that section. I go to the consolidated file, and
paste special. I choose Paste Link: Microsoft Excel 8.0 Format.

The consolidated file shows the #REF after doing so. I did the same process
for the previous three files, and everything worked fine. Can anyone help?

Thanks,
TM