Excel 2000 to 2002 - #NAME?

[Guest]

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

 

[Guest]

When you updated did you update all addins like the Analysis Toolpak

 

[Gord Dibben]

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

 

[Dave Peterson]

If you haven't found the solution, you may want to post a formula that's causing
the trouble.

 

[Guest]

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]

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.

 

[Guest]

Ok Dave, i will follow your advice.

Thank you.

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.