I have a spreadhseet that is linked to 4 other spreadsheets.

Three of the links appear to work fine, but for the fourth, the linked cell shows #VALUE! instead of the number from the linked file.

If I open the linked file, then the correct value will appear. But once I close the linked file, the cell shows #VALUE! again.

As far as I can tell, the file types are similar (All have been saved as Excel workbooks) and I am using Excel 2003.

Help?

Thanks.