If you open both files, does the formula calculate correctly?

Does the formula point at the correct file (dropping the drive and path)?

And if you close the "sending" file and recalc, do you still get that error
message?

I don't have a guess, but maybe someone else will with further information.

Fluke wrote:

I don't. I get a dialog box that says 'Unable to read file'.

"Bernard Liengme" wrote:

What you should get when the source file is not open is a #VALUE error
best wishes
Bernard Liengme
MVP Excel

"Fluke" wrote in message
...
Hi

I'm using Sumproduct to count rows that meet certain criteria in external
worksheets. If the other sheets are open everything is fine. If not,
then I
get the error 'Unable to read file'.

Can anyone help please? All the files are valid xls files and the path in
the sumproduct formula is fine.


--

Dave Peterson