Some functions do not work when linked to closed external workbooks.

Dave
--
Brevity is the soul of wit.


" wrote:

Help!! I have a spreadsheet which is linked to about 30 other
spreadsheets.
Most of the functions are just 'sum's and 'sumif''s.
When I have all spreadsheets open, the values are updated in the main
spreadsheet.
If I close the linked spreadsheets, I will lose the values to the main
spreadsheet.
The resulting error is '#value'.

All the links are linked properly to the right spreadsheet. I've also
opened them one at a time and saved my main spreadsheet. What else can
I do?

Thanks in advance!!!