Formula not working if an Excel file in sent in attachement

  • Thread starter Thread starter ludovic
  • Start date Start date
L

ludovic

Hi,

I built a file with some rounding formulas (mround) and
it's working without problem on my computer, but if I
send it to somebody in attachment to an Email, all the
cells with the "mround" formula are labeled with the
error message: #name.

If anybody knows why...

thank you

regards

ludovic
 
From xl's help:

MROUND

Returns a number rounded to the desired multiple.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

======
So it's tools|Addins|check analysis toolpak.
(You may need the installation CD)
 
Back
Top