Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
I received a spreadsheet via e-mail and when I opened it all was fine.
Formulas appearing to working perfectly. As soon as I saved it to my computer a whole column changed to #NAME? in place of the values that were in their. The formula in the first cell is: =IF(I42="","",NETWORKDAYS(A42,I42,NonWorkDays2008)-1). The named range "NonWorkDays2008" is in a worksheet within the same workbook. What would cause this? This was not doing this on the computer it was sent from. Connie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
Hello Connie,
NETWORKDAYS is an Analysis ToolPak add-in function. You need to enable the add-in on every computer on which the spreadsheet is accessed. Go to Tools menu and then "add-ins", tick "Analysis ToolPak". |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
I'd guess you don't have the Analysis Toolpak Add-in installed and are
using XL03 or earlier (just guesses since you didn't say what version of XL you're using). Load the add-in using Tools/Add-ins... In article , Connie Martin wrote: I received a spreadsheet via e-mail and when I opened it all was fine. Formulas appearing to working perfectly. As soon as I saved it to my computer a whole column changed to #NAME? in place of the values that were in their. The formula in the first cell is: =IF(I42="","",NETWORKDAYS(A42,I42,NonWorkDays2008)-1). The named range "NonWorkDays2008" is in a worksheet within the same workbook. What would cause this? This was not doing this on the computer it was sent from. Connie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
Thank you! That did it! This is a new PC and I had that enabled on my old
PC but when I installed Office on this PC, I didn't remember these add-ins. Thank you so much. You've made my task so much easier!! Connie "barry houdini" wrote: Hello Connie, NETWORKDAYS is an Analysis ToolPak add-in function. You need to enable the add-in on every computer on which the spreadsheet is accessed. Go to Tools menu and then "add-ins", tick "Analysis ToolPak". |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
Thank you. That was it exactly. It's working now. Thanking so much for
responding. Connie "JE McGimpsey" wrote: I'd guess you don't have the Analysis Toolpak Add-in installed and are using XL03 or earlier (just guesses since you didn't say what version of XL you're using). Load the add-in using Tools/Add-ins... In article , Connie Martin wrote: I received a spreadsheet via e-mail and when I opened it all was fine. Formulas appearing to working perfectly. As soon as I saved it to my computer a whole column changed to #NAME? in place of the values that were in their. The formula in the first cell is: =IF(I42="","",NETWORKDAYS(A42,I42,NonWorkDays2008)-1). The named range "NonWorkDays2008" is in a worksheet within the same workbook. What would cause this? This was not doing this on the computer it was sent from. Connie |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
It's always worth remembering that Excel help will usually give you the
answer. Just type the function name NETWORKDAYS into Excel help. -- David Biddulph "Connie Martin" wrote in message ... Thank you! That did it! This is a new PC and I had that enabled on my old PC but when I installed Office on this PC, I didn't remember these add-ins. Thank you so much. You've made my task so much easier!! Connie "barry houdini" wrote: Hello Connie, NETWORKDAYS is an Analysis ToolPak add-in function. You need to enable the add-in on every computer on which the spreadsheet is accessed. Go to Tools menu and then "add-ins", tick "Analysis ToolPak". |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
I did, but I guess I must've missed it. Will try to dig more the next time.
Thank you. "David Biddulph" wrote: It's always worth remembering that Excel help will usually give you the answer. Just type the function name NETWORKDAYS into Excel help. -- David Biddulph "Connie Martin" wrote in message ... Thank you! That did it! This is a new PC and I had that enabled on my old PC but when I installed Office on this PC, I didn't remember these add-ins. Thank you so much. You've made my task so much easier!! Connie "barry houdini" wrote: Hello Connie, NETWORKDAYS is an Analysis ToolPak add-in function. You need to enable the add-in on every computer on which the spreadsheet is accessed. Go to Tools menu and then "add-ins", tick "Analysis ToolPak". |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME?
Hi Connie,
It's nice to know the Microsoft had this issue in mind when the created 2007 - now all the Analysis ToolPak functions are built into Excel, so when everybody has made the transition to 2007 or later this problem will evaporate. But we still have the Analysis ToolPak in 2007, why? Because the Data Analysis command, on the Tools menu in 2003 is still not built into Excel, but that's another issue entirely. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Connie Martin" wrote: Thank you. That was it exactly. It's working now. Thanking so much for responding. Connie "JE McGimpsey" wrote: I'd guess you don't have the Analysis Toolpak Add-in installed and are using XL03 or earlier (just guesses since you didn't say what version of XL you're using). Load the add-in using Tools/Add-ins... In article , Connie Martin wrote: I received a spreadsheet via e-mail and when I opened it all was fine. Formulas appearing to working perfectly. As soon as I saved it to my computer a whole column changed to #NAME? in place of the values that were in their. The formula in the first cell is: =IF(I42="","",NETWORKDAYS(A42,I42,NonWorkDays2008)-1). The named range "NonWorkDays2008" is in a worksheet within the same workbook. What would cause this? This was not doing this on the computer it was sent from. Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|