Add-In Data Toolpak Help

[MBAApple]

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.

 

[CyberTaz]

One question at a time see interjections below...

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

 

[Guest]

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!

 

[CyberTaz]

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