Hello all, I have a someone sharing excel 2007 spreadsheets with others using
excel 2003. She is saving it in the 2003 format and everyone has the
neccesary toopak addin's installed but they randomly get the #N/A error with
the following formula's:

=(YIELD(TODAY()+3,L11,((VLOOKUP(YEAR(L11)-YEAR(TODAY()),$Q$12:$R$27,2,FALSE)+J12/100))/100,I12,100,4)*100)

=YIELD($AC$1,K4,D4+$T$2,I4,100,4)


Is there any workaround to this compatibility issue? or do they all need to
be on the same version?

Thanks in advance,
Eddie