Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Analysis Add-in EOMONTH generates #NAME? error
I have used the EOMONTH function successfully. But I transferred my workbook
to someone who did not have the needed add-in installed so it generated a #NAME? error. So I installed the add-in on his computer but it did not resolve the #NAME? error. I took his workbook and put it back on my computer and it still generates the #NAME? error. But if I open my original file the EOMONTH works. I can flip between the two open workbooks and see the error on his file, but not on mine. Tried F9 to force a recompute, no help? Any ideas? |
#2
|
|||
|
|||
Hi!
When you say: "I installed the add-in on his computer" Does that mean it was also loaded? Goto ToolsAdd-Ins Is Analysis ToolPak checked? An alternative to using Eomonth and does not need the ATP: Date in A1 = 1/1/2005 =DATE(YEAR(A1),MONTH(A1)+1,0) Biff "Ray" wrote in message ... I have used the EOMONTH function successfully. But I transferred my workbook to someone who did not have the needed add-in installed so it generated a #NAME? error. So I installed the add-in on his computer but it did not resolve the #NAME? error. I took his workbook and put it back on my computer and it still generates the #NAME? error. But if I open my original file the EOMONTH works. I can flip between the two open workbooks and see the error on his file, but not on mine. Tried F9 to force a recompute, no help? Any ideas? |
#3
|
|||
|
|||
Try re-registering the formulas *after* you install the Add-In.
Select a range of cells containing some of these formulas, then: <Edit <Replace In "Find what", enter = In "Replace With", enter = Then <Replace All -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ray" wrote in message ... I have used the EOMONTH function successfully. But I transferred my workbook to someone who did not have the needed add-in installed so it generated a #NAME? error. So I installed the add-in on his computer but it did not resolve the #NAME? error. I took his workbook and put it back on my computer and it still generates the #NAME? error. But if I open my original file the EOMONTH works. I can flip between the two open workbooks and see the error on his file, but not on mine. Tried F9 to force a recompute, no help? Any ideas? |
#4
|
|||
|
|||
Yes, i'm having the same exact problem. I tried the suggestion below by Ragdyer, but it does not seem to work. The excel file that is showing the "#NAME?" was created about 10 years ago, so the problem seems to have to do with newer versions of Excel trying to use an Excel file created many years prior. If anyone has any further suggestions, I'd love to hear about them. My only option it seems is to rewrite all the formulas that use EOMONTH. Thanks, Jeff "Ragdyer" wrote: Try re-registering the formulas *after* you install the Add-In. Select a range of cells containing some of these formulas, then: <Edit <Replace In "Find what", enter = In "Replace With", enter = Then <Replace All -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ray" wrote in message ... I have used the EOMONTH function successfully. But I transferred my workbook to someone who did not have the needed add-in installed so it generated a #NAME? error. So I installed the add-in on his computer but it did not resolve the #NAME? error. I took his workbook and put it back on my computer and it still generates the #NAME? error. But if I open my original file the EOMONTH works. I can flip between the two open workbooks and see the error on his file, but not on mine. Tried F9 to force a recompute, no help? Any ideas? |
#5
|
|||
|
|||
Have you installed the ATP add-in first?
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "jefftlewis" wrote in message ... Yes, i'm having the same exact problem. I tried the suggestion below by Ragdyer, but it does not seem to work. The excel file that is showing the "#NAME?" was created about 10 years ago, so the problem seems to have to do with newer versions of Excel trying to use an Excel file created many years prior. If anyone has any further suggestions, I'd love to hear about them. My only option it seems is to rewrite all the formulas that use EOMONTH. Thanks, Jeff "Ragdyer" wrote: Try re-registering the formulas *after* you install the Add-In. Select a range of cells containing some of these formulas, then: <Edit <Replace In "Find what", enter = In "Replace With", enter = Then <Replace All -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ray" wrote in message ... I have used the EOMONTH function successfully. But I transferred my workbook to someone who did not have the needed add-in installed so it generated a #NAME? error. So I installed the add-in on his computer but it did not resolve the #NAME? error. I took his workbook and put it back on my computer and it still generates the #NAME? error. But if I open my original file the EOMONTH works. I can flip between the two open workbooks and see the error on his file, but not on mine. Tried F9 to force a recompute, no help? Any ideas? |
#6
|
|||
|
|||
Yes, I have. I was able to solve the problem. I changed my macro security setting from "High" to "Medium". Then when you are asked to accept macros (when you open the file in question), you say yes. I guess the EOMONTH function, or the ATP add-in, requires a macro? Thanks for your reply. This discussion group seems like a pretty handy resource. I frequently have detailed Excel questions, and don't know where to turn. Regards, Jeff "RagDyer" wrote: Have you installed the ATP add-in first? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "jefftlewis" wrote in message ... Yes, i'm having the same exact problem. I tried the suggestion below by Ragdyer, but it does not seem to work. The excel file that is showing the "#NAME?" was created about 10 years ago, so the problem seems to have to do with newer versions of Excel trying to use an Excel file created many years prior. If anyone has any further suggestions, I'd love to hear about them. My only option it seems is to rewrite all the formulas that use EOMONTH. Thanks, Jeff "Ragdyer" wrote: Try re-registering the formulas *after* you install the Add-In. Select a range of cells containing some of these formulas, then: <Edit <Replace In "Find what", enter = In "Replace With", enter = Then <Replace All -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ray" wrote in message ... I have used the EOMONTH function successfully. But I transferred my workbook to someone who did not have the needed add-in installed so it generated a #NAME? error. So I installed the add-in on his computer but it did not resolve the #NAME? error. I took his workbook and put it back on my computer and it still generates the #NAME? error. But if I open my original file the EOMONTH works. I can flip between the two open workbooks and see the error on his file, but not on mine. Tried F9 to force a recompute, no help? Any ideas? |
#7
|
|||
|
|||
Now you know where to come.<g
Appreciate the feed-back. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jefftlewis" wrote in message ... Yes, I have. I was able to solve the problem. I changed my macro security setting from "High" to "Medium". Then when you are asked to accept macros (when you open the file in question), you say yes. I guess the EOMONTH function, or the ATP add-in, requires a macro? Thanks for your reply. This discussion group seems like a pretty handy resource. I frequently have detailed Excel questions, and don't know where to turn. Regards, Jeff "RagDyer" wrote: Have you installed the ATP add-in first? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "jefftlewis" wrote in message ... Yes, i'm having the same exact problem. I tried the suggestion below by Ragdyer, but it does not seem to work. The excel file that is showing the "#NAME?" was created about 10 years ago, so the problem seems to have to do with newer versions of Excel trying to use an Excel file created many years prior. If anyone has any further suggestions, I'd love to hear about them. My only option it seems is to rewrite all the formulas that use EOMONTH. Thanks, Jeff "Ragdyer" wrote: Try re-registering the formulas *after* you install the Add-In. Select a range of cells containing some of these formulas, then: <Edit <Replace In "Find what", enter = In "Replace With", enter = Then <Replace All -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ray" wrote in message ... I have used the EOMONTH function successfully. But I transferred my workbook to someone who did not have the needed add-in installed so it generated a #NAME? error. So I installed the add-in on his computer but it did not resolve the #NAME? error. I took his workbook and put it back on my computer and it still generates the #NAME? error. But if I open my original file the EOMONTH works. I can flip between the two open workbooks and see the error on his file, but not on mine. Tried F9 to force a recompute, no help? Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I add Data Analysis Tool Pak to my Excel 2000? | Excel Discussion (Misc queries) | |||
How do I prepare a comparitive analysis graph in Excel | Charts and Charting in Excel | |||
I cannot load the Analysis Toolpak in Excel 2003 like Microsoft H. | Excel Discussion (Misc queries) |