#name? error message

[spekeklein]

I have just installed my Office X Excel for Mac on my new computer
(running Leopard). I have tried to open an old file, created in Excel
2001, which has macros, and has information linked to another
workbook. When I allow the file to update the linked info some of my
cells with formulas show the #NAME? error.

The first cell showing the error has the formula =MROUND(I32, 5)
and the others are related to this first cell.

Some of the preceding cells that influence I32 are linked to other
workbooks. Could the problem have to do with a broken link?

There is no name in the formula, other than the cell reference.

Any help would be greatly appreciated!

Thanks.

 

[Jim Gordon MVP]

Hi,

I know Excel 2004 has on the Edit menu a Links option. Not sure about v.X.

-Jim

I have just installed my Office X Excel for Mac on my new computer
(running Leopard). I have tried to open an old file, created in Excel
2001, which has macros, and has information linked to another
workbook. When I allow the file to update the linked info some of my
cells with formulas show the #NAME? error.

The first cell showing the error has the formula =MROUND(I32, 5)
and the others are related to this first cell.

Some of the preceding cells that influence I32 are linked to other
workbooks. Could the problem have to do with a broken link?

There is no name in the formula, other than the cell reference.

Any help would be greatly appreciated!

Thanks.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Bob Greenblatt]

Hi,

I know Excel 2004 has on the Edit menu a Links option. Not sure about v.X.

-Jim

Make sure the analysis Tool Pack is installed.

 

[JE McGimpsey]

I have just installed my Office X Excel for Mac on my new computer
(running Leopard). I have tried to open an old file, created in Excel
2001, which has macros, and has information linked to another
workbook. When I allow the file to update the linked info some of my
cells with formulas show the #NAME? error.

The first cell showing the error has the formula =MROUND(I32, 5)
and the others are related to this first cell.

Some of the preceding cells that influence I32 are linked to other
workbooks. Could the problem have to do with a broken link?

There is no name in the formula, other than the cell reference.

Any help would be greatly appreciated!

It's most likely that you don't have the Analysis Toolkpak Add-in
installed (Tools/Add-ins...).

However, MROUND is often more trouble than it's worth:

=MROUND(I32, 5)

can be easily replaced with a built-in function:

=ROUND(I32/5, 0) * 5

which is actually faster and more efficient than using the add-in.

 

[spekeklein]

It's most likely that you don't have the Analysis Toolkpak Add-in
installed (Tools/Add-ins...).

However, MROUND is often more trouble than it's worth:

=MROUND(I32, 5)

can be easily replaced with a built-in function:

=ROUND(I32/5, 0) * 5

which is actually faster and more efficient than using the add-in.

Thanks for the info about MROUND. Good to know.

I think the answer is the Analysis ToolPak. If I install it, where
should it go?

Thanks!!

 

[JE McGimpsey]

I think the answer is the Analysis ToolPak. If I install it, where
should it go?

The default location for the ATP is

HD:Applications:Microsoft Office 2004:Office:Add-ins:Analysis Tools

but you can put it anywhere.