Unchecking and Rechecking Analysis Toolpak

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TKrepitch@aol.com - 23 Apr 2007 23:10 GMT

I have created and distributed a file that requires users to have the
Analysis Toolpak add-ins enabled on their computers. For most people,
it works fine, but there are a few who are having problems with it.

The file requires users to enter input numbers and the file will
calculate profitability numbers, including IRR using the XIRR
function. I have instructed all users to check off the two related
add-ins and normally that is all it takes and it works fine. However,
there are a few who do not get results unless they uncheck (deselect)
those two boxes, then reselect them. It works, but that's a pain and
obviously not something they should have to do.

Does anyone know what could be causing this? It is some kind of Excel
or pc setting that I'm not familiar with? Thanks in advance! :)

Reply to this Message

Nick Hodge - 23 Apr 2007 23:24 GMT

I suspect they do not have it actually installed It has to be installed
specifically in some versions

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

>I have created and distributed a file that requires users to have the
> Analysis Toolpak add-ins enabled on their computers. For most people,
[quoted text clipped - 10 lines]
> Does anyone know what could be causing this? It is some kind of Excel
> or pc setting that I'm not familiar with? Thanks in advance! :)

Reply to this Message

TKrepitch@aol.com - 23 Apr 2007 23:59 GMT

Hmm. I think everyone is on Excel 2003. When they first start up,
they go into the menu and select the two boxes.

Seems like that should take care of it and it usually does, but there
are some people who have to deselect then reselect each time. It's
really weird. :(

Reply to this Message

Bruce Sinclair - 24 Apr 2007 00:37 GMT

>Hmm. I think everyone is on Excel 2003. When they first start up,
>they go into the menu and select the two boxes.
>
>Seems like that should take care of it and it usually does, but there
>are some people who have to deselect then reselect each time. It's
>really weird. :(

I have seen this (it happens to me). I was led to believe that it is
something to do with system settings/protections. Are the people who have to
uncheck/recheck in a different organisation to you ? ... or maybe at a
different site with different security settings ?

I have not heard of a fix ... if you find one I'd love to know :)

Thanks

Reply to this Message

TKrepitch@aol.com - 24 Apr 2007 16:12 GMT

On Apr 23, 4:37 pm, bruce.sincl...@NOSPAMORELSEagresearch.NOTco.NOTnz

> In article <1177369177.733195.139...@l77g2000hsb.googlegroups.com>, TKrepi...@aol.com wrote:
> >Hmm. I think everyone is on Excel 2003. When they first start up,
[quoted text clipped - 12 lines]
>
> Thanks

Well, we are in the same company, but I am in Finance and they are in
Sales. Same location. I've been trying to figure out what the people
who are having the problem have in common, but haven't found anything
yet. It seems to be somewhat random, although obviously there must be
something. :) I'll let you know if I figure out what's going on.

Reply to this Message

Bruce Sinclair - 30 Apr 2007 00:22 GMT

>On Apr 23, 4:37 pm, bruce.sincl...@NOSPAMORELSEagresearch.NOTco.NOTnz
>> In article <1177369177.733195.139...@l77g2000hsb.googlegroups.com>,
[quoted text clipped - 20 lines]
>yet. It seems to be somewhat random, although obviously there must be
>something. :) I'll let you know if I figure out what's going on.

Thanks :)

I'd start by asking your IT guys if the finance and sales sections have
different system security settings. Sounds likely (or at least possible :) )
to me. Best of luck.

Reply to this Message

Michael Bednarek - 24 Apr 2007 03:29 GMT

On 23 Apr 2007 15:59:37 -0700, TKrepitch@... wrote in
microsoft.public.excel:

>Hmm. I think everyone is on Excel 2003. When they first start up,
>they go into the menu and select the two boxes.

... and press the OK button, I presume? Have you observed them?

>Seems like that should take care of it and it usually does, but there
>are some people who have to deselect then reselect each time. It's
>really weird. :(

Nick Hodge made the point that the Analysis Toolpack might not be
installed on those PCs - it is an optional component during installation
and not installed by default. See:
<http://office.microsoft.com/en-us/excel/hp011277241033.aspx>.

It's not clear to me whether this explains the odd behaviour of some of
your PCs.

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message

TKrepitch@aol.com - 24 Apr 2007 16:26 GMT

> On 23 Apr 2007 15:59:37 -0700, TKrepitch@... wrote in
> microsoft.public.excel:
[quoted text clipped - 18 lines]
> --
> Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

That's a good question. I've really only told them how to set it up
over the phone or via email, so I can't verify that they actually
clicked "OK", but I have seen those two boxes checked off when I've
gone to see their computers.

I guess I'm a little unclear about whether there is a difference
between "loading" and "installing". Is there more that has to be done
than selecting the Toolpak buttons and clicking OK? That is all I've
been telling people to do and it's been working for most people. The
link above (thanks, btw) seems to be saying that you would only get a
message if it wasn't already installed. Also, if the function works
after deselecting and then reselecting the boxes, then I'd have to
think that the program is actually installed. Of course, I could be
completely misunderstanding this. LOL.

Still stumped.

Reply to this Message

TKrepitch@aol.com - 24 Apr 2007 19:17 GMT

> On 23 Apr 2007 15:59:37 -0700,TKrepitch@... wrote in
> microsoft.public.excel:
[quoted text clipped - 18 lines]
> --
> Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

I hope this isn't being posted twice, but I don't think my first
attempt worked. I haven't really watched anyone do the checking of
the boxes and pressing ok, but I've seen the boxes checked when I've
gone down to look at their computers, so I think they did actually
press ok.

I guess I'm a little confused if there's a difference between loading
and installing. The link above (thanks, btw) seems to say that you
would get a special message if the toolpak wasn't installed and that
has never happened before. Also, if the function works after the
boxes have been unchecked and rechecked, that would mean that the
toolpak was installed, I'd think. So I would guess that the toolpak
is installed and loaded, but just not working all the time. I have to
figure out what is happening when I uncheck and recheck the boxes.
Still stumped. :(

Reply to this Message

Rate this thread: