ADDin not working

R

RAGS

I have an excel sheet with some charts and statistics functions in it (which
needs the analysis toll pack 1 & 2). it was created in 2003 version and was
working fine for years. Now after installing office 2007, i am getting an
error in this sheets. it asks me to enable the analysis tool pack 1 &2. but
it is already enabled. I have enabled tool pack 1,2 and all macros, but still
its asking me to enable the ATP 1&2.
i am running this office 2007 in XP-SP3

Any solutions?
Thanks in advance
 
J

Jerry W. Lewis

Most (all?) functions that were in previous versions of ATP are native Excel
functions in 2007, and so are not duplicated in the 2007 ATP. Change the
formula so that it simply calls the function without reference to ATP and the
formula should work. If not, post back with the specific function(s) you are
trying to use.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not able to enable macros in the workbooks (since today/16.jun) !! 1
Analysis Tool Pack addin into Excel and it is not loading 2
No Analysis Tool Pack=EDATE formula not working! HELP!! 8
Excel 2007 imaging / shawdowing on screen 1
Error with Compatibility Pack for 2007 Office 2
old macros not working properly 3
Analysis Tool Pack 2
Excel 2007 crashes after refreshing data linked to external source 0

Top