Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #name? error in cells after sending spreadsheet via email
I have a spreadsheet that calculates delivery forecast by week. I have 24
weeks. The user enters the customer's weekly demand and it autocalculates how many they have on hand and how much we need to send in order to meet the demand. The user is suppose to just enter what the inventory on hand is and their weekly demands. The spreadsheet has formulas that calculates whether they have enough inventory or tells the user how many to send at a given week to meet the demand. It works great in my computer but when I send it to someone else via email and they start to enter their information, they get a #NAME? error in all the cells that have the formulas. I tried sending the spreadsheet with selected cells locked, the formula's hidden and the worksheet protected. Then I tried sending it totally unlocked, unhidden and unprotected and was getting the same error. The formulas are correct and it works in my computer, but when I send it someone else, it gives that error. We checked the formatting and all are the same. What gives? Thank you for all of your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #name? error in cells after sending spreadsheet via email
Are you using functions that are part of the Analysis ToolPak? That
could explain any name errors. Btw, you should post an example formula that gives error. It's easier -- Regards, Peo Sjoblom "rexie3" wrote in message ... I have a spreadsheet that calculates delivery forecast by week. I have 24 weeks. The user enters the customer's weekly demand and it autocalculates how many they have on hand and how much we need to send in order to meet the demand. The user is suppose to just enter what the inventory on hand is and their weekly demands. The spreadsheet has formulas that calculates whether they have enough inventory or tells the user how many to send at a given week to meet the demand. It works great in my computer but when I send it to someone else via email and they start to enter their information, they get a #NAME? error in all the cells that have the formulas. I tried sending the spreadsheet with selected cells locked, the formula's hidden and the worksheet protected. Then I tried sending it totally unlocked, unhidden and unprotected and was getting the same error. The formulas are correct and it works in my computer, but when I send it someone else, it gives that error. We checked the formatting and all are the same. What gives? Thank you for all of your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #name? error in cells after sending spreadsheet via email
Did you perhaps use a formula that is included in an Add-in? Such as the
Analysis ToolPak. If so, whoever you send it to may need to 'turn on' that add-in as well. I know this same thing happened to me once when I used the NETWORKDAYS function. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "rexie3" wrote: I have a spreadsheet that calculates delivery forecast by week. I have 24 weeks. The user enters the customer's weekly demand and it autocalculates how many they have on hand and how much we need to send in order to meet the demand. The user is suppose to just enter what the inventory on hand is and their weekly demands. The spreadsheet has formulas that calculates whether they have enough inventory or tells the user how many to send at a given week to meet the demand. It works great in my computer but when I send it to someone else via email and they start to enter their information, they get a #NAME? error in all the cells that have the formulas. I tried sending the spreadsheet with selected cells locked, the formula's hidden and the worksheet protected. Then I tried sending it totally unlocked, unhidden and unprotected and was getting the same error. The formulas are correct and it works in my computer, but when I send it someone else, it gives that error. We checked the formatting and all are the same. What gives? Thank you for all of your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #name? error in cells after sending spreadsheet via email
Hi,
1. It means that the spreadsheet is employing one or more of the 100 functions which are part of the Analysis ToolPak. Tell the user to choose Tools, Add-ins, and check the box beside Analysis ToolPak. 2. A far less likely issue is that you sent the Excel file from a 2007 or to someone using 2003 or earlier. Certain uses of range address will potentially cause Name error messages when the file is opened in 2003. For example, suppose you reference =XFD1 in 2007 and return it to a 2003 user, there is a name problem. I could also come up with a senario where moving the file from 2003 to 2007 would result in a Name error. -- If this helps, please click the Yes button Cheers, Shane Devenshire "rexie3" wrote: I have a spreadsheet that calculates delivery forecast by week. I have 24 weeks. The user enters the customer's weekly demand and it autocalculates how many they have on hand and how much we need to send in order to meet the demand. The user is suppose to just enter what the inventory on hand is and their weekly demands. The spreadsheet has formulas that calculates whether they have enough inventory or tells the user how many to send at a given week to meet the demand. It works great in my computer but when I send it to someone else via email and they start to enter their information, they get a #NAME? error in all the cells that have the formulas. I tried sending the spreadsheet with selected cells locked, the formula's hidden and the worksheet protected. Then I tried sending it totally unlocked, unhidden and unprotected and was getting the same error. The formulas are correct and it works in my computer, but when I send it someone else, it gives that error. We checked the formatting and all are the same. What gives? Thank you for all of your help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #name? error in cells after sending spreadsheet via em
Thank you for your help. It was the issue of the Analysis Toolpak not being
installed in the user's computer. "Shane Devenshire" wrote: Hi, 1. It means that the spreadsheet is employing one or more of the 100 functions which are part of the Analysis ToolPak. Tell the user to choose Tools, Add-ins, and check the box beside Analysis ToolPak. 2. A far less likely issue is that you sent the Excel file from a 2007 or to someone using 2003 or earlier. Certain uses of range address will potentially cause Name error messages when the file is opened in 2003. For example, suppose you reference =XFD1 in 2007 and return it to a 2003 user, there is a name problem. I could also come up with a senario where moving the file from 2003 to 2007 would result in a Name error. -- If this helps, please click the Yes button Cheers, Shane Devenshire "rexie3" wrote: I have a spreadsheet that calculates delivery forecast by week. I have 24 weeks. The user enters the customer's weekly demand and it autocalculates how many they have on hand and how much we need to send in order to meet the demand. The user is suppose to just enter what the inventory on hand is and their weekly demands. The spreadsheet has formulas that calculates whether they have enough inventory or tells the user how many to send at a given week to meet the demand. It works great in my computer but when I send it to someone else via email and they start to enter their information, they get a #NAME? error in all the cells that have the formulas. I tried sending the spreadsheet with selected cells locked, the formula's hidden and the worksheet protected. Then I tried sending it totally unlocked, unhidden and unprotected and was getting the same error. The formulas are correct and it works in my computer, but when I send it someone else, it gives that error. We checked the formatting and all are the same. What gives? Thank you for all of your help. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #name? error in cells after sending spreadsheet via em
Thank you for your help. It was the issue of the Analysis Toolpak not being
installed in the user's computer. "Luke M" wrote: Did you perhaps use a formula that is included in an Add-in? Such as the Analysis ToolPak. If so, whoever you send it to may need to 'turn on' that add-in as well. I know this same thing happened to me once when I used the NETWORKDAYS function. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "rexie3" wrote: I have a spreadsheet that calculates delivery forecast by week. I have 24 weeks. The user enters the customer's weekly demand and it autocalculates how many they have on hand and how much we need to send in order to meet the demand. The user is suppose to just enter what the inventory on hand is and their weekly demands. The spreadsheet has formulas that calculates whether they have enough inventory or tells the user how many to send at a given week to meet the demand. It works great in my computer but when I send it to someone else via email and they start to enter their information, they get a #NAME? error in all the cells that have the formulas. I tried sending the spreadsheet with selected cells locked, the formula's hidden and the worksheet protected. Then I tried sending it totally unlocked, unhidden and unprotected and was getting the same error. The formulas are correct and it works in my computer, but when I send it someone else, it gives that error. We checked the formatting and all are the same. What gives? Thank you for all of your help. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #name? error in cells after sending spreadsheet via em
Thank you for your help. It was the issue of the Analysis Toolpak not being
installed in the user's computer. "Peo Sjoblom" wrote: Are you using functions that are part of the Analysis ToolPak? That could explain any name errors. Btw, you should post an example formula that gives error. It's easier -- Regards, Peo Sjoblom "rexie3" wrote in message ... I have a spreadsheet that calculates delivery forecast by week. I have 24 weeks. The user enters the customer's weekly demand and it autocalculates how many they have on hand and how much we need to send in order to meet the demand. The user is suppose to just enter what the inventory on hand is and their weekly demands. The spreadsheet has formulas that calculates whether they have enough inventory or tells the user how many to send at a given week to meet the demand. It works great in my computer but when I send it to someone else via email and they start to enter their information, they get a #NAME? error in all the cells that have the formulas. I tried sending the spreadsheet with selected cells locked, the formula's hidden and the worksheet protected. Then I tried sending it totally unlocked, unhidden and unprotected and was getting the same error. The formulas are correct and it works in my computer, but when I send it someone else, it gives that error. We checked the formatting and all are the same. What gives? Thank you for all of your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
error sending email (as attachment) from within Excel 2000 | Excel Discussion (Misc queries) | |||
Sending email from excel spreadsheet | Excel Discussion (Misc queries) | |||
Sending spreadsheet via email with recipents addy | Excel Discussion (Misc queries) | |||
How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) |