User Defined Function Opens Improperly - Round II
(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
|