ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   analysis toolpak (https://www.excelbanter.com/excel-discussion-misc-queries/17338-analysis-toolpak.html)

Ashanti

analysis toolpak
 
How do get this add in! tried using tools function and re-installing cd, but
not happening!

Ken Wright

All you *should* have to do is hit Tools / Addins / Check the Analysis
Toolpak addin and then you may or may not be prompted for the disk. This
then gives you extra functions you can use and some more options under
Tools.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ashanti" wrote in message
...
How do get this add in! tried using tools function and re-installing cd,

but
not happening!




Gord Dibben

Ashanti

Analysis Toolpak is an add-in that should have installed with Office and
Excel.

Do you see it when you go to ToolsAdd-ins? If not, do a file search for
these files........make sure Windows is set to "show hidden files".

Look for them in your Office10 Library first.

C:\Program Files\Microsoft Office\Office10\Library\Analysis

Four files in here.......

ANALYS32.XLL
ATPVBAEN.XLA
FUNCRES.XLA
PROCDB.XLA

When you do the install do you select "typical" or "custom"? The typical
install will include the toolpak add-in.

If you cannot find anywhere on Hard Drive suggest you plop in the Office CD
and do a partial install through Control PanelAdd/RemoveChange. Perhaps
uninstall the add-in components then re-install.


Gord Dibben Excel MVP

On Sat, 12 Mar 2005 04:53:02 -0800, "Ashanti"
wrote:

How do get this add in! tried using tools function and re-installing cd, but
not happening!




All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com