Hi
this is just the usage of your syntax. Your kind of cell reference is
just not correct for closed workbooks

--
Regards
Frank Kabel
Frankfurt, Germany

"Stephen POWELL" schrieb im
Newsbeitrag ...
Thanks, Frank. I forgot to mention that when I open all the source
workbooks
the linking formulas in the destination workbook produce the correct
results.
You may be on to something so I went back and re-performed the
EVALUATE
FORMULA and the way I first presented it is accurate. I'm still
baffled.

"Frank Kabel" wrote:

Hi
this is not a valid reference you have created. The valid reference
would look like:
SUM('path\[filename]\worksheet'!$C$27:$J$27)

You may post the complete formula

--
Regards
Frank Kabel
Frankfurt, Germany

"Stephen POWELL" schrieb
im
Newsbeitrag
...
1. Working in a network environment.
2. My dependent workbook in one subdirectory links to several
source
workbooks all in one other directory (this has never been a
problem
before).
3. All such linking formulas show "#REF!". But everything worked
fine last
week when I created the dependent workbook with its links.
4. Formula in dependent workbook is:
SUM(INDEX(...BLAH...BLAH):INDEX(...BLAH...BLAH))
5. I have used TOOLS/FORMULA AUDITING/EVALUATE FORMULA to confirm
that the
INDEX arguments within the SUM formula each evaluate to the
proper
cells in
the source workbooks. In other words, I proceeded through
EVALUATE
FORMULA
until I got


SUM('path\[filename]\worksheet'!$C$27:'path\[filename]\worksheet'!$J$27
) and
the next EVALUATE step produced the "REF!".

Any suggestions?
Many thanks,
Stephen Powell