Add-In Data Toolpak Help   

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I'm trying to access the Excel Data Analysis TooPack add-in. It's not showing up as an option. Will this be on my original disk if I try and re-install Excel? Or can I just pop in the disk and install this addition? Is it possible I have a version of 2004 that does not have the ToolPack or do all versions come with this option?

I'm starting my MBA this fall and just bought a new MacBook Pro(intel dual processor). Sounds like I shouldn't bother upgrading to 2007 or 2008 since they lack the charting tools that I may need?

I am getting ready to upgrade to Leopard. Will 2004 work in Leopard?

Another MBA student on a Mac. :)

date: Fri, 4 Jul 2008 15:31:50 -0800   author:   unknown

Re: Add-In Data Toolpak Help   

One question at a time:-) see interjections below...


On 7/4/08 7:31 PM, in article 59b53456.-1@webcrossing.caR9absDaxw,
"MBAApple@officeformac.com"  wrote:

> Version: 2004
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: intel
> 
> I'm trying to access the Excel Data Analysis TooPack add-in. It's not showing
> up as an option. Will this be on my original disk if I try and re-install
> Excel? Or can I just pop in the disk and install this addition? Is it possible
> I have a version of 2004 that does not have the ToolPack or do all versions
> come with this option?

There should be no need to reinstall - the Add-Ins can be obtained from the
original disk (although I can't remember exactly which one). IIRC, the
Add-Ins were included with all editions of 2004.

First, do a Spotlight search in Finder for Add-ins to see if the folder
exists but has been moved to the wrong location. It should be in:

~/Applications/Microsoft Office 2004/Office

If you find it elsewhere move it to that folder & you should be able to load
them through Tools> Add-ins.

> 
> I'm starting my MBA this fall and just bought a new MacBook Pro(intel dual
> processor). Sounds like I shouldn't bother upgrading to 2007 or 2008 since
> they lack the charting tools that I may need?

Well, 2008 definitely not - it ,doesn't support VBA [on which the Add-ins
rely] so they wouldn't be available at all. OTOH, 2007 is a different story.
That is a Windows version which does still support VBA & does still include
the Add-ins. However, you'll also need a copy of the Window OS & run it in
Boot Camp or one of the emulation apps (Parallels, VM Ware Fusion, etc.) in
order to use any of the Office 2007 programs.

> 
> I am getting ready to upgrade to Leopard. Will 2004 work in Leopard?

Yes, Office 2004 runs on 10.5.x although not *quite* as quick on Intel Macs
as it does on PPC-based Macs (because of running through Rosetta).

> 
> Another MBA student on a Mac. :)

HTH |:>) 
Bob Jones 
[MVP] Office:Mac

date: Sat, 05 Jul 2008 13:07:41 -0400   author:   CyberTaz

Re: Add-In Data Toolpak Help   

This is outrageous! I can't use my new Apple to perform statistical analysis that would have been possible on an older mode??!! What is your problem Microsoft??!! I need this for my masters degree program. Thanks for nothing!

date: Sun, 13 Jul 2008 19:36:19 -0800   author:   unknown

Re: Add-In Data Toolpak Help   

First of all, pull in your horns :-) - "Microsoft" isn't here. This is a
community of users who work with the product just as you do. If you want to
lodge any complaints or rant about the changes you'd be better off using
Help> Send Feedback to put your comments where MS will see them.

Second, it's already been announced that VBA will be restored in the next
version, so the return of add-in convenience should be restored as well.

Third, all the functions used by the previous add-ins are available as
built-in functions which enable the same capabilities - it's just a bit more
work since you don't have the "fill-in-the-blank" dialogs. Also, if you
search the Excel newsgroup on the subject you'll find that there are
alternatives available for many of the missing tools - some of which are
allegedly better than the add-ins :-)

Regards |:>)
Bob Jones 
[MVP] Office:Mac



On 7/13/08 11:36 PM, in article 59b53456.1@webcrossing.caR9absDaxw, "" <>
wrote:

> This is outrageous! I can't use my new Apple to perform statistical analysis
> that would have been possible on an older mode??!! What is your problem
> Microsoft??!! I need this for my masters degree program. Thanks for nothing!

date: Mon, 14 Jul 2008 17:20:13 -0400   author:   CyberTaz