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

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



rexie3 wrote:

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

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 HelpDetect and Repair would be of some help.

Have CD ready in case you need it.


Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 13:28:01 -0700, rexie3
wrote:

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