I have a spreadsheet with links to other excel files. (All excel 2003). When
I open the spreadsheet, the cells all show #VALUE! until I open the other
spreadsheets that the links refer to. Is there any to fix this so that the
updates work without opening the other spreadsheets.

Thank you advance.

Tim