Hi there

I am currently working on a spreadsheet which conatins formulas that
link to numerous other spreadsheets.

The problem I am having is that when you open the new spreasdheet, in
the cells which contain formulas linking to the other spreadsheets they
display #VALUE! unless you actually open the source spreadsheets.

I want the formulas in the cells to update without the user having to
open the source spreadsheet, otherwise there will be no point in having
the new spreadsheet! I don't want the users to have to open numerous
spreadsheets to view the information they need.

One thing I have noticed is that cells that link to another spreadsheet
(but do not incorporate formulas) are working fine, although you do have
to enter the password needed to access that particular source
spreadsheet.

Can anyone help with this?

Thanks!


--
Brokovich
------------------------------------------------------------------------
Brokovich's Profile: http://www.excelforum.com/member.php...o&userid=37098
View this thread: http://www.excelforum.com/showthread...hreadid=570724