Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MROUND function disappears
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. Thanks -- Don A. LAN/Telecommunications Coord. Mystic Stamp Co. |
#2
|
|||
|
|||
Never heard of it before, you can use a non ATP function te replace MROUND,
for instance MROUND(1.3, 0.2) returns 1.4 (round to neares 0.2) and the built in round =ROUND(1.3/0.2,0)*0.2 will do the same in fact I try to stay away from the as much as possible since you never know if you send someone a workbook and they haven't installed it. Regards, Peo Sjoblom "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. Thanks -- Don A. LAN/Telecommunications Coord. Mystic Stamp Co. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |