AddIn Analysis Pak not working anymore

R

rexie3

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
 
D

Dave Peterson

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top