Hi Dave,

This sounds like an issue that we'd definitely want to look into. I've got
a couple requests for you -

1. Can you try this on B2TR (now available for download) if you haven't
already?
2. If this still repros in B2TR, can you send me the solution (via email)
that repro's this so I can take a look with current builds and get a bug
filed if there's still a problem?

Cheers,
Dan
Excel Team

Note: We've only got a couple weeks to get bugs filed and fixed, so if I've
requested additional info via email, it'd be great if you can get that to us
ASAP. Please include any necessary sample files, as well as detailed repro
steps so that we can try to reproduce the problem on our side. Also - if
you're emailing me directly (definitely the most efficient at this point)
you'll want to fixup my email address to remove everything after danbatt and
before the @.





"Dave F" wrote in message
...
So I have a spreadsheet with a bunch of cells that use a UDF. Sometimes
when
I open the spreadsheet, some of the cells that have this UDF show a #NAME
error. Pressing F9 seems to clear these errors.

Is there some setting which forces UDFs to calculate automatically?

This is the code I'm using, if curious:

Function GetFormula(Cell As Range) As String
GetFormula = Cell.Formula
If Cell.HasArray Then GetFormula = "{" & GetFormula & "}"
End Function

If I eliminate the If...Then clause I still sometimes get the #NAME error,
sometimes not. So the code I have is not creating the error, so far as I
can
tell...

Ideas?

--
Brevity is the soul of wit.