ACCTINTM problems after upgrading to Excel 2003

A

Andrew Edwards

the function: =ACCRINTM(B2,B3,B4,B5,B6)
worked perfectly in Excel 2000 but results in #NAME? in after upgrading
to 2003. Any idea why?

Thanks in advance,
Andrew
 
H

Harlan Grove

Andrew Edwards wrote...
the function: =ACCRINTM(B2,B3,B4,B5,B6)
worked perfectly in Excel 2000 but results in #NAME? in after upgrading
to 2003. Any idea why?

Online help is always the best first place to look.

It's provided by the Analysis ToolPak add-in, which is *never* loaded
by default in any version of Excel. You need to run Tools > Add-ins to
load it. You or someone else must have done that in your previous Excel
version.
 
Top