I would love to be able to fix the problem, but your work around solutions
may have to do. I am extremely appreciative of your suggetions. Thanks you.`

"JE McGimpsey" wrote:

I've no idea why MROUND is "turn(ing) itself off", but MROUND is a
derivative function, so it can be replaced with native XL functions with
no problems.

For example, if the current formula is

=MROUND(A1, 2)

The you can use

=ROUND(A1/2, 0)*2

Similarly, replace

=MROUND(A1, 0.25)

with

=ROUND(A1/0.25, 0)*0.25

or, equivalently,

=ROUND(A1*4, 0)/4

In article ,
Don A. wrote:

When using MROUND, the MROUND function turns itself off randomly and all the
cells that used MROUND become non-functional. To restart MROUND, we have to
uncheck the Analysis Toolpak and then checkmark it again. We don't reboot or
close the worksheet. This happens on Excel XP and 2003, on all different
computers. Present PC is XP Pro, 3GHz P4, 1GB RAM. The excel files are
located on a Windows 2000 server.

This is becoming very frustrating for the user. We can't find any posts on
the subject. I can't beleive we're the only ones experiencing this problem.

Any help will be appreciated.