Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having a problem with 2001 compatable functions in 2007
Fore Example, this one:
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 It is in a cell in the worksheet and was working fine in 2001, but now in 2007, changes to #NAME? if I cause it to rebuild, for example by clicking on the cell so that it shows in the formula bar, then putting the cursor at the end & hitting enter. I tried adding "Public" but there was no effect. This and other function are in "Module1" If I click on an empty cell and then click the Insert Function fx spot, the name shows, but it is telling me that the function takes no arguments. You can clearly see the arguments above. One by one my precious formulas upon which my grade for my summer course entirely depends, are being eaten by 2007, and summer is about over so all I can say is: HELP! Thank You, -plh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having a problem with 2001 compatable functions in 2007
In article ,
?B?cGxo?= says... Fore Example, this one: 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 It is in a cell in the worksheet and was working fine in 2001, but now in 2007, changes to #NAME? if I cause it to rebuild, for example by clicking on the cell so that it shows in the formula bar, then putting the cursor at the end & hitting enter. I tried adding "Public" but there was no effect. This and other function are in "Module1" If I click on an empty cell and then click the Insert Function fx spot, the name shows, but it is telling me that the function takes no arguments. You can clearly see the arguments above. One by one my precious formulas upon which my grade for my summer course entirely depends, are being eaten by 2007, and summer is about over so all I can say is: HELP! Thank You, -plh 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 -- Where are we going and why am I in this HAND BASKET?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 'contain featrures that are not compatable with Web Pag | Excel Discussion (Misc queries) | |||
Office 2007: #NAME error on UD formulas that were fine in 2001 | Excel Programming | |||
How do I convert a compatable workbook back to 2007 format? | Excel Discussion (Misc queries) | |||
Is Excel 2007 completely backward compatable? | Excel Programming | |||
5.0 Not Compatable | Excel Programming |