YIELD is a custom function - i.e. it won't be on everyones install of Excel.
Likely the YIELD function is sitting in her PERSONAL.XLS file or within some
other spreadsheet that she normally has open (or in an Excel add-in that she
uses and other don't).

Either track down where the YIELD function is stored on her system and get
it embeded into the file she's sending out or put it into everyone else's
PERSONAL.XLS file. Or have her rewrite the formula to avoid the YIELD
function.

"Eddie" wrote:

Hello all, one of my users keeps getting this error #Name? for the following
yield fomula
=(YIELD(TODAY()+3,L10,((VLOOKUP(YEAR(L10)-YEAR(TODAY()),$P$7:$Q$22,2,FALSE)+J11/100))/100,I11,100,4)*100)

She fixes it and when she sends it to someone else they get the error or if
she opens it at a later time she gets the #Name? again. It was created in
excel 2003 but then she used excel 2007 to make changes but saves it in 2003
format.

Any help would be much appreciated.

Thanks,
Eddie