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?