Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Force Re-Install of Analysis Toolpak?
I tried to select the Analysis Toolpak (sic) Add-In for Office 2003 and I
think the install didn't complete correctly. After install I still cannot use the XNPV function and get #NAME? error. How can I force a de-install and re-install of Analysis Toolpak? -- Will |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Force Re-Install of Analysis Toolpak?
The ATP is available under ToolsAdd-ins?
You have it checked? Try unchecking, close dialog then ToolsAdd-ins and re-check it. If not available have a look in the default install folder. C:\Program Files\Microsoft Office\Office11\Library\Analysis There will be 4 files in the Analysis folder. ANALYS32.XLL FUNCRES.XLA ATPVBAEN.XLA PROCDB.XLA If not found there, suggest you try the control panel add/removechange and go in and remove the ATP installation then re-install just the ATP Assuming you have the installation CD, of course. Gord Dibben MS Excel MVP On Wed, 8 Oct 2008 11:43:41 -0700, "Will" wrote: I tried to select the Analysis Toolpak (sic) Add-In for Office 2003 and I think the install didn't complete correctly. After install I still cannot use the XNPV function and get #NAME? error. How can I force a de-install and re-install of Analysis Toolpak? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Force Re-Install of Analysis Toolpak?
Go to Tools - Add Ins and uncheck the Toolpak.
Click OK. Go back and click it again. Course, if it isn't checked initially, that's your issue... "Will" wrote: I tried to select the Analysis Toolpak (sic) Add-In for Office 2003 and I think the install didn't complete correctly. After install I still cannot use the XNPV function and get #NAME? error. How can I force a de-install and re-install of Analysis Toolpak? -- Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpak | Excel Worksheet Functions | |||
Analysis Toolpak | Excel Discussion (Misc queries) | |||
Can't install Analysis ToolPak for Office XP | Setting up and Configuration of Excel | |||
Why does PHStats *NOT* install when I install Analytical ToolPak? | Setting up and Configuration of Excel | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |