Excel 2000 function compatibility

  • Thread starter Thread starter Araten
  • Start date Start date
A

Araten

I have an excel 2000 spreadsheet that has financial
functions (PMT, CUMInt,etc..) that works fine in excel
2000 but gets errors in excel 2002. Anyway to run it in
excel 2002?
 
Hnormally there shouldn't be any problems. You may post
your exact formula and the concrete error you get (wrong
result, error value, etc.)
 
CUMIPMT requires the Analysis Toolpak Add-In. If it isn't installed you will
get a #NAME error (literally because Excel doesn't recognize the name of the
Formula you're trying to use since the Analysis Toolpak isn't loaded).

While PMT does not require the AddIn, if there are formula dependencies to
cells that do require it, that might explain the errors.
 
Back
Top