Installing Add-ins

[mflibra]

I'm running Excel 2004 on the MAC OS X 10.4

I believe it's an educational version---this may or may not b
relevant.

When I click on TOOLS > Add-ins to install the Analysis Toolpak

I notice that all of them are checked. I click OK to install them bu
nothing happens.

I know for a fact that they are not installed as many of th
functionality available on my PC version of Excel 2000 is not present!

Can anyone help me install the Add-ins!

Greatly appreciate it

 

[NickHK]

So if you type "=EOMONTH(NOW(),5)" in any cell, do you get "#NAME?" returned
?

NickHK

 

[mflibra]

That's Exactly what you get

 

[NickHK]

Apart from suggesting you follow the instruction to install/remove,
load/unload addins, as described in Help, under the EOMONTH entry (where it
says "How?"), I can't say much as I don't have a Mac.
The file IS on your system is it ? Called something like "Analys32.xll".
You can load it for that session of Excel by opening it the same as any
other file. See if that works.

NickHK