Formula stops working after re-opening worksheet

[watchtower]

I am using the formula =intrate(settlement,maturity,investment,redemption)
When I open up a fresh worksheet this formula is available. Once I save and
close the worksheet, then re-open the file, the cell displays "#NAME?" and I
can no longer use this formula. Other formulas work fine, but I cannot even
find this formula using the function search. Any thoughts?

 

[David Biddulph]

Are you trying to open it on a machine that doesn't have the Analysis
ToolPak Add-In loaded?

 

[watchtower]

I had the Analysis ToolPak Add-In selected, but not the Analysis ToolPak VBA
Add-In. I selected the VBA and it works! Thanks!