Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why can't I see Analysis Toolpak functions when I have loaded it .
I've added the Analysis Toolpak via Tools, Addins, yet Excel doesn't seem to
have loaded the addin. I don't have access to the toolpak's functions, and the Data Analysis option doesn't appear on the Tools menu, suggesting it hasn't been loaded up - yet the check box remains ticked in the Tools Addin window. Any ideas why Excel doesn't seem to be recognising/loading the addin? |
#2
|
|||
|
|||
Just a thought,
Do you have any other add-ins running that may be re-setting the command bar to it's default? Gary Brown "Nige" wrote: I've added the Analysis Toolpak via Tools, Addins, yet Excel doesn't seem to have loaded the addin. I don't have access to the toolpak's functions, and the Data Analysis option doesn't appear on the Tools menu, suggesting it hasn't been loaded up - yet the check box remains ticked in the Tools Addin window. Any ideas why Excel doesn't seem to be recognising/loading the addin? |
#3
|
|||
|
|||
Any chance you installed the "Analysis Toolpak - VBA" and not the plain
vanilla "Analysis Toolpak"? "Nige" wrote: I've added the Analysis Toolpak via Tools, Addins, yet Excel doesn't seem to have loaded the addin. I don't have access to the toolpak's functions, and the Data Analysis option doesn't appear on the Tools menu, suggesting it hasn't been loaded up - yet the check box remains ticked in the Tools Addin window. Any ideas why Excel doesn't seem to be recognising/loading the addin? |
#4
|
|||
|
|||
Thanks for the thought Gary - but no, in fact the thing that alerted me to
the problem was a sheet I created which checks for and loads up the Toolpak addins. I tried re-starting Excel and Windows and using new workbooks etc to double check nothing I had open was affecting it. The confusing thing is it's checked as loaded, and there's no error message, but no sign of any of the functions... Only clue I can think of is that it's only just started happening out of the blue, and there's a possibility other people have saved the workbook (that needs the toolpak functions) as a previous version of Excel - but this has never been a problem before. Nige "Gary Brown" wrote: Just a thought, Do you have any other add-ins running that may be re-setting the command bar to it's default? Gary Brown "Nige" wrote: I've added the Analysis Toolpak via Tools, Addins, yet Excel doesn't seem to have loaded the addin. I don't have access to the toolpak's functions, and the Data Analysis option doesn't appear on the Tools menu, suggesting it hasn't been loaded up - yet the check box remains ticked in the Tools Addin window. Any ideas why Excel doesn't seem to be recognising/loading the addin? |
#5
|
|||
|
|||
Thanks, but no - I generally use both of them, and this has started happening
out of the blue... "Duke Carey" wrote: Any chance you installed the "Analysis Toolpak - VBA" and not the plain vanilla "Analysis Toolpak"? "Nige" wrote: I've added the Analysis Toolpak via Tools, Addins, yet Excel doesn't seem to have loaded the addin. I don't have access to the toolpak's functions, and the Data Analysis option doesn't appear on the Tools menu, suggesting it hasn't been loaded up - yet the check box remains ticked in the Tools Addin window. Any ideas why Excel doesn't seem to be recognising/loading the addin? |
#6
|
|||
|
|||
From Excel, press Alt-F11 to call up the Visual Basic Editor. Make sure the
Project Explorer is displayed in the top left - it will list all the open workbooks. If funcres.xla IS NOT listed, then it isn't installed/opened. If it is listed, then it's installed but not working properly. After testing to see whether it's there, report back to the newsgroup and wait for a reply from somebody with more experience than I have. "Nige" wrote: Thanks, but no - I generally use both of them, and this has started happening out of the blue... "Duke Carey" wrote: Any chance you installed the "Analysis Toolpak - VBA" and not the plain vanilla "Analysis Toolpak"? "Nige" wrote: I've added the Analysis Toolpak via Tools, Addins, yet Excel doesn't seem to have loaded the addin. I don't have access to the toolpak's functions, and the Data Analysis option doesn't appear on the Tools menu, suggesting it hasn't been loaded up - yet the check box remains ticked in the Tools Addin window. Any ideas why Excel doesn't seem to be recognising/loading the addin? |
#7
|
|||
|
|||
You could be on to something there.. I've occasionally had error messages
about funcres.xla, I think saying it couldn't be loaded, when I was closing Excel (or maybe closing windows, can't remember for sure) and haven't tracked it all to see what the pattern is. I didn't know funcres was related to addin functionality - useful to know, thanks. I didn't check what you suggest before I found a fix - I unchecked Toolpak addin and then closed XL, reopened, reloaded Toolpak and it started working again - but doubtless the problem will arise again so if/when it does I'll see if funcres appears and post back. Thanks again, Nige "Duke Carey" wrote: From Excel, press Alt-F11 to call up the Visual Basic Editor. Make sure the Project Explorer is displayed in the top left - it will list all the open workbooks. If funcres.xla IS NOT listed, then it isn't installed/opened. If it is listed, then it's installed but not working properly. After testing to see whether it's there, report back to the newsgroup and wait for a reply from somebody with more experience than I have. "Nige" wrote: Thanks, but no - I generally use both of them, and this has started happening out of the blue... "Duke Carey" wrote: Any chance you installed the "Analysis Toolpak - VBA" and not the plain vanilla "Analysis Toolpak"? "Nige" wrote: I've added the Analysis Toolpak via Tools, Addins, yet Excel doesn't seem to have loaded the addin. I don't have access to the toolpak's functions, and the Data Analysis option doesn't appear on the Tools menu, suggesting it hasn't been loaded up - yet the check box remains ticked in the Tools Addin window. Any ideas why Excel doesn't seem to be recognising/loading the addin? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis toolpak | Setting up and Configuration of Excel | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
I cannot load the Analysis Toolpak in Excel 2003 like Microsoft H. | Excel Discussion (Misc queries) |