Thank you for the suggestion, Mike. I hadn't thought of that. That
will certainly work when the cell formula happens to use Choose, and
the arguments contain the file names in explicit fashion. But it might
not be using Choose, or the file names might come from yet other cells.

I'm going to try to rephrase my question better.

If the result of a formula in a cell produces a reference to a cell in
another workbook, how can one determine the name of that file, and the
worksheet in that file?

Excel itself does this because it successfully fetches the value in
that cell.

If I use Value or Evaluate, I just get the displayed contents of the
referenced cell. I think I'm looking for some clever use of Dependents
or Precedents, but I have been able to find anything that works. Or
maybe a way to use Evaluate on the cell formula, but to get a reference
to the cell that the formula result points to.

Thanks,

Brian