(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.

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

Thanks Much,

SteveM

format the column suitable to the function returning type
--
hemu


"SteveM" wrote:

(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.

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

Thanks Much,

SteveM

A string of #### generally indicates a column being to narrow to display its
contents. Also a 'negative' date can give this effect. What datatype does
your function compute?
Does widening the cell make any difference?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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

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

Thanks Much,

SteveM