#name? error message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

spekeklein@hotmail.com - 21 Dec 2007 00:26 GMT

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.

Reply to this Message

Jim Gordon MVP - 21 Dec 2007 00:53 GMT

Hi,

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

-Jim

Quoting from "spekeklein@hotmail.com" <spekeklein@hotmail.com>, in article
2d7263a9-a547-4482-ae03-cab0934ba2fe@21g2000hsj.googlegroups.com, on [DATE:

> 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
[quoted text clipped - 13 lines]
>
> Thanks.

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

Bob Greenblatt - 21 Dec 2007 13:43 GMT

On 12/20/07 7:53 PM, in article
C39078CD.26455%goldkey74@WarmerThanWarmMail.com, "Jim Gordon MVP"
<goldkey74@WarmerThanWarmMail.com> wrote:

> Hi,
>
[quoted text clipped - 22 lines]
>> >
>> > Thanks.

Make sure the analysis Tool Pack is installed.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

JE McGimpsey - 21 Dec 2007 17:57 GMT

In article
<2d7263a9-a547-4482-ae03-cab0934ba2fe@21g2000hsj.googlegroups.com>,

> 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
[quoted text clipped - 11 lines]
>
> 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.

Reply to this Message

spekeklein@hotmail.com - 21 Dec 2007 20:55 GMT

> In article
> <2d7263a9-a547-4482-ae03-cab0934ba...@21g2000hsj.googlegroups.com>,
[quoted text clipped - 28 lines]
>
> 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!!

Reply to this Message

JE McGimpsey - 21 Dec 2007 23:45 GMT

In article
<6876604a-9af7-4e82-b618-d0471cc7134f@e4g2000hsg.googlegroups.com>,

> 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.

Reply to this Message

Mac Forum / Applications / Excel / December 2007

#name? error message