View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default EDATE & #NA Errors

Edate and all the ATP functions are built into Excel 2007. So you
definitely do not need or want the ATP attached. Beyond that you might see
Ron's page here if a non-English language is involved. I don't use these
functions much so that's the extent of my "knowledge".

http://www.rondebruin.nl/atp.htm

--
Jim
"cardan" wrote in message
...
| Hello,
| I recently switched to Excel 2007 and I am still using and modifying
| models created in Excel 2003. Sometimes, I am getting the #NA errors
| where my EDATE function is supposed to be when I open the file. It
| seems to have something with transferring between Excel 2003 and 2007
| versions. When I close and open the file in 2007 that seems to be when
| the issue occurs. Sometimes it works and sometimes it doesn't. I have
| the analysis toolpak active as well as automatic calculations. I
| haven't been able to pinpoint why or how to fix. Any suggestions?
| Thank you for your time in advance. DJC