What's the "#### error" ? That typically means your column is too narrow
to display the value.

Tim

"SteveM" wrote in message
...
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.

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

Thanks Much,

SteveM