ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   ACCTINTM problems after upgrading to Excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/73964-acctintm-problems-after-upgrading-excel-2003-a.html)

Andrew Edwards

ACCTINTM problems after upgrading to Excel 2003
 
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

Harlan Grove

ACCTINTM problems after upgrading to Excel 2003
 
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.



All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com