(This a repost to bubble the query back to the top.  Still seeking a
solution.)

I wrote a couple of functions with data links to a second workbook.

The data workbook is already open when I open the workbook with the
functions.  However the cells containing the functions open up the
"####" error designator, not the function return value.  When I open
the function dialog box attached to a cell, I can see that it
calculates properly and the return value is correct.  And I can repair
the problem by simply closing the dialog box by clicking OK.

PLEASE NOTE THAT THIS IS NOT A PROBLEM WITH THE COLUMN WIDTH

If I widen the column the #### changes to this:

First the #Name? error designator appears for a moment then changes to
the #Value! designator.  Which I can repair by opening and closing the
associated dialog box for just one cell.  I can drag the repaired cell
down the column to repair the other cells with the same formula.

So it must be a lag linking up with the data source.  But if it is, I
don't know how to fix it.

Any ideas on how to prevent the fault from appearing at all?

Thanks Much,