AddIn Analysis Pak not working anymore

[Guest]

I have an excel sheet that calculates a customer's usage forecast. I use
formulas like MROUND and IF statements. For some reason I'm getting a #Name?
error now in the MROUND formula. My first formula is =MROUND(F5,D3).

My Tools, AddIns has both Analysis Paks checked off and this spreadsheet has
worked before. I don't know what has happened to make this function not work
anymore.

Is there a test I can do to see if I have a file missing all of a sudden
from my desktop? Or how can I reload my addins?

Thank you very much in advance

 

[Dave Peterson]

In xl2003, I'd do:
Tools|Addins
and uncheck the analysis toolpak
then select it once more

 

[Gord Dibben]

If you don't have any typing errors in your formulas and the ATP is loaded you
should not be getting the #NAME? error.

Have you tried unloading ATP, closing Excel, reopening then loading ATP again?

Is calculation set to automatic?

Maybe Help>Detect and Repair would be of some help.

Have CD ready in case you need it.


Gord Dibben MS Excel MVP