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?