Hi--

What do you mean by cells that refer to other workbooks, but which are not
in formulas, work fine? Any cell which references another workbook is, by
definition, a formula.

In any event, have your users go to Tools-->Options-->Calculation, and click
Update remote references and save external link values. See if that solves
the problem.

"Brokovich" wrote:

>
> 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
>
>