Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2000 to 2002 - #NAME?
Hi,
I have recently updated my Excel 2000 to 2002 (XP). But i noticed that when i open a file that works in 2000, in 2002 i just have #NAME? in cells. What i need to do? Thanks. Paulo Freixieiro |
#2
|
|||
|
|||
When you updated did you update all addins like the Analysis Toolpak
"Paulo Freixieiro" wrote: Hi, I have recently updated my Excel 2000 to 2002 (XP). But i noticed that when i open a file that works in 2000, in 2002 i just have #NAME? in cells. What i need to do? Thanks. Paulo Freixieiro |
#3
|
|||
|
|||
This error flag usually denotes that a Function being used is not available to
the workbook in question, but there are other reasons. From Help on "errors" and #NAME? *************************** Possible causes and solutions Using a function that is part of the Analysis Toolpak add-in, without the add-in being loaded Install and load the Analysis Toolpak add-in. How? On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program. Using a name that does not exist Make sure the name exists. On the Insert menu, point to Name, and then click Define. If the name is not listed, add the name by using the Define command. Misspelling the name Verify the spelling. Select the name in the formula bar , press F3, click the name you want to use, and then click OK. Using a label in a formula, without labels being allowed Allow labels to be used. On the Tools menu, click Options, and then click the Calculation tab. Under Workbook options, select the Accept labels in formulas check box. Misspelling the name of a function Correct the spelling. Insert the correct function name into the formula by clicking Function on the Insert menu. Entering text in a formula without enclosing the text in double quotation marks (Excel tries to interpret your entry as a name even though you intended it to be used as text.) Enclose text in the formula in double quotation marks. For example, the following formula joins the piece of text "The total amount is " with the value in cell B50: ="The total amount is "&B50 Omitting a colon (:) in a range reference Make sure all range references in the formula use a colon (:); for example, SUM(A1:C10). Referencing another sheet not enclosed in single quotation marks. ********************************************** Gord Dibben Excel MVP On Tue, 6 Sep 2005 17:17:38 -0700, "Paulo Freixieiro" <Paulo wrote: Hi, I have recently updated my Excel 2000 to 2002 (XP). But i noticed that when i open a file that works in 2000, in 2002 i just have #NAME? in cells. What i need to do? Thanks. Paulo Freixieiro |
#4
|
|||
|
|||
If you haven't found the solution, you may want to post a formula that's causing
the trouble. Paulo Freixieiro wrote: Hi, I have recently updated my Excel 2000 to 2002 (XP). But i noticed that when i open a file that works in 2000, in 2002 i just have #NAME? in cells. What i need to do? Thanks. Paulo Freixieiro -- Dave Peterson |
#5
|
|||
|
|||
As this formula is not an excel formula, i guess that is behind a macro:
=EVGTS($B$1;$B$11) The workbook is locked and i could not see some cell's. "Dave Peterson" wrote: If you haven't found the solution, you may want to post a formula that's causing the trouble. Paulo Freixieiro wrote: Hi, I have recently updated my Excel 2000 to 2002 (XP). But i noticed that when i open a file that works in 2000, in 2002 i just have #NAME? in cells. What i need to do? Thanks. Paulo Freixieiro -- Dave Peterson |
#6
|
|||
|
|||
This function doesn't look familiar to anything I've seen in the USA English
version of excel. And since you're getting #name? errors, I'd guess it's not something that comes with excel (either built-in or in the analysis toolpak). My bet is you had an addin installed in the earlier version that isn't installed on xl2002 (tools|addins). (Or you could have had another addin located in your XLStart folder.) I think you'll have to find that addin. If you're lucky, it might be listed in Tools|Addins. If you're not so lucky, any chance you have a co-worker that uses the same addin. Maybe you could walk by his/her desk and take a peak at what's installed. If you find the addin and don't have a copy on your pc (if you upgraded your existing pc, it's probably there), take a copy with you. I just got back from a google search for EVGTS in the *Excel* newsgroups. I saw one earlier thread (the same problem as you). But no details back from the original poster. This might be a coincidence or it could mean that the addin is a bought and paid for product. It might not be a good thing to just copy the file without examining the End User License Agreement for that product. Paulo Freixieiro wrote: As this formula is not an excel formula, i guess that is behind a macro: =EVGTS($B$1;$B$11) The workbook is locked and i could not see some cell's. "Dave Peterson" wrote: If you haven't found the solution, you may want to post a formula that's causing the trouble. Paulo Freixieiro wrote: Hi, I have recently updated my Excel 2000 to 2002 (XP). But i noticed that when i open a file that works in 2000, in 2002 i just have #NAME? in cells. What i need to do? Thanks. Paulo Freixieiro -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Ok Dave, i will follow your advice.
Thank you. "Dave Peterson" wrote: This function doesn't look familiar to anything I've seen in the USA English version of excel. And since you're getting #name? errors, I'd guess it's not something that comes with excel (either built-in or in the analysis toolpak). My bet is you had an addin installed in the earlier version that isn't installed on xl2002 (tools|addins). (Or you could have had another addin located in your XLStart folder.) I think you'll have to find that addin. If you're lucky, it might be listed in Tools|Addins. If you're not so lucky, any chance you have a co-worker that uses the same addin. Maybe you could walk by his/her desk and take a peak at what's installed. If you find the addin and don't have a copy on your pc (if you upgraded your existing pc, it's probably there), take a copy with you. I just got back from a google search for EVGTS in the *Excel* newsgroups. I saw one earlier thread (the same problem as you). But no details back from the original poster. This might be a coincidence or it could mean that the addin is a bought and paid for product. It might not be a good thing to just copy the file without examining the End User License Agreement for that product. Paulo Freixieiro wrote: As this formula is not an excel formula, i guess that is behind a macro: =EVGTS($B$1;$B$11) The workbook is locked and i could not see some cell's. "Dave Peterson" wrote: If you haven't found the solution, you may want to post a formula that's causing the trouble. Paulo Freixieiro wrote: Hi, I have recently updated my Excel 2000 to 2002 (XP). But i noticed that when i open a file that works in 2000, in 2002 i just have #NAME? in cells. What i need to do? Thanks. Paulo Freixieiro -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 to 2002 - #NAME? | Excel Discussion (Misc queries) | |||
Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |