Office 2007: #NAME error on UD formulas that were fine in 2001
 

I have changed a 2001 worksheet having numerous user defined functions such as:

Function VEPT_Pre(Sigma, ProcessTime, MTTF, MTTR)
'Variance of effective Process Time page 262 Formula 8.6
'pre-emtive failures
VEPT_Pre = (Sigma / Availability(MTTF, MTTR)) ^ 2 + _
((2 * ProcessTime * MTTR * (1 - Availability(MTTF, MTTR))) / Availability(MTTF,
MTTR))

End Function

These were working fine in 2001 but now in 2008 as Process.xlsm They are
generating #NAME errors. I was using them on one of the worksheets. If I try to
put one in a new cell the "insert function" fx at the end of the formula bar can
see it, but claims that it takes no arguments. But you can easily see the
arguments up there.
What do I have to do to get them to work again?
Thank You,
-plh


--
Where are we going and why am I in this HAND BASKET??

Office 2007: #NAME error on UD formulas that were fine in 2001
 

Oh my dears! So this IS the same list that a access through my email account.
Sorry for posting the same question twice. But I must tell you that I am in a
terrible fix & need help because my grade for the summer depends on this and
the summer is almost over!
Thanx,
-plh

"plh" wrote:

I have changed a 2001 worksheet having numerous user defined functions such as:

Function VEPT_Pre(Sigma, ProcessTime, MTTF, MTTR)
'Variance of effective Process Time page 262 Formula 8.6
'pre-emtive failures
VEPT_Pre = (Sigma / Availability(MTTF, MTTR)) ^ 2 + _
((2 * ProcessTime * MTTR * (1 - Availability(MTTF, MTTR))) / Availability(MTTF,
MTTR))

End Function

These were working fine in 2001 but now in 2008 as Process.xlsm They are
generating #NAME errors. I was using them on one of the worksheets. If I try to
put one in a new cell the "insert function" fx at the end of the formula bar can
see it, but claims that it takes no arguments. But you can easily see the
arguments up there.
What do I have to do to get them to work again?
Thank You,
-plh


--
Where are we going and why am I in this HAND BASKET??

Office 2007: #NAME error on UD formulas that were fine in 2001
 

In article ,
?B?cGxo?= says...

Alas! I think I have helped myself. I thought I told it to turn on Macros but
there turned out to be another place I had to do that. These are my Macros, of
course I trust them!
-plh


Oh my dears! So this IS the same list that a access through my email account.
Sorry for posting the same question twice. But I must tell you that I am in a
terrible fix & need help because my grade for the summer depends on this and
the summer is almost over!
Thanx,
-plh

"plh" wrote:

I have changed a 2001 worksheet having numerous user defined functions such as:

Function VEPT_Pre(Sigma, ProcessTime, MTTF, MTTR)
'Variance of effective Process Time page 262 Formula 8.6
'pre-emtive failures
VEPT_Pre = (Sigma / Availability(MTTF, MTTR)) ^ 2 + _
((2 * ProcessTime * MTTR * (1 - Availability(MTTF, MTTR))) / Availability(MTTF,
MTTR))

End Function

These were working fine in 2001 but now in 2008 as Process.xlsm They are
generating #NAME errors. I was using them on one of the worksheets. If I try to
put one in a new cell the "insert function" fx at the end of the formula bar can
see it, but claims that it takes no arguments. But you can easily see the
arguments up there.
What do I have to do to get them to work again?
Thank You,
-plh


--
Where are we going and why am I in this HAND BASKET??



--
Where are we going and why am I in this HAND BASKET??