Why are german users getting an error with Mround? ATP installed.

S

Stumblinthrulife

I have a workbook that uses the MROUND function. It is used globally, and
once ATP is installed, there are typically no problems. However, I have now
had two incidents where German users still get the dreaded "#name" error. I
have confirmed that they have the Analysis Toolpak (Analyse-Funktionen is
German) installed.

Is MROUND in a different Toolpak in the German version? This seems unlikely,
but I'm clutching at straws at this point.
 
B

Bob Phillips

The Analysis Toolpak Functions are language sensitive. So you nee VRUNDEN.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

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

Similar Threads

MROUND replaced with #N/A in Excel 2007 2
Error opening in German Excel 4
Excel 2007 - Data May Be Lost - MRound function replaced with #N/A? 1
An issue with "References" in VBA 7
"Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Pleas 0
Code exected at "Workbook Open" slowing/stopping file from opening 0
German (DE) Script Error in Project Web Access 0
Run time error 1004 Unable to set the installed property of Addin 0

Top