Problem with updating links in Excel 2003
 

Five spreadsheets, collective size around 150 MB. Knee deep in formulas,
functions and figures. All five workbooks are linked to each other, thus it
is necessary to open them all at one time. Unfortunately, this isnt
possible. Each time the fifth sheet is opened, you receive the following
error:

"Excel cannot complete this task with available resources. Choose less data
or close other apps."