Accessing Add-Ins Tab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. B. - 08 Nov 2007 04:00 GMT

Hello,

I recently installed Office 2007 Enterprise Edition on my laptop. During
the installation it prompted me if I would like to upgrade or to remove all
the previous versions (Office 2003). I opted to remove and do a custom
install so that I could install some add-ins to some of the Office
applications. My problem is that when I try to access the Excel Add-Ins tab
that displays upon clicking on the Excel Options button I get an error. The
error comes up in an a dialog box stating that "Microsoft Office Excel has
encounter a problem and needs to close. We are sorry for the inconvenience."
This only happens using Excel. All other Office applications allow me to
access and enable Add-Ins. If anyone has idea of how to solve this issue it
would be much appreciated. I am able to open the SOLVER.XLAM file and work
from there but I cannot get it to stay on the Data ribbon.

Thanks in advance,

J. B.

Reply to this Message

Nick Hodge - 08 Nov 2007 20:26 GMT

J.B

Try going to Excel options and selecting the add-ins tab and then next to
the dropdown at the bottom (that should say Excel add-ins) click 'Go'.
Disable everything in this list and then restart Excel and see if it goes
away. If it does, add one back at a time (re-start excel between iterations)
and that will be your faulting add-in.

If this doesn't work be suspicious of anything you may have loaded as dll
add-ins. Culprits generally are Adobe, Norton, etc but it could be any
application that interfaces with Excel

Signature

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

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html

> Hello,
>
[quoted text clipped - 15 lines]
>
> J. B.

Reply to this Message

ilia - 08 Nov 2007 21:25 GMT

Using the same method, you'd look for dll add-ins under COM Add-Ins
and re-enable one by one. With Acrobat Pro 8.0 (which actually
inserts its own tab and is quite handy in Excel), I had a hangup where
I had to disable it - Excel actually told me that "If you press OK and
this dialog box pops up again, click the Disable button". So then I
had to remove it, readd it, and reenable it to get it back to work.

I'm also having some issues with Solver - not all the time, but
occasionally when I go to the Data tab, it will say "SOLVER.XLAM
cannot be found".

> J.B
>
[quoted text clipped - 41 lines]
>
> - Show quoted text -

Reply to this Message

J. B. - 09 Nov 2007 00:47 GMT

Nick,

First, I want to thank everyone for replying to my post. Second, the problem
occurs when you click on the Add-ins tab under Excel Options. Once the tab
is clicked on the CPU utilization goes to a 100% and then the the error
dialog box appears. I wish I could just access the Add-Ins tab. Does
anyone have any suggestions?

Thanks again in advance,

JB

> J.B
>
[quoted text clipped - 27 lines]
>>
>> J. B.

Reply to this Message

Ed Hansberry, MS-MVP/Mobile Devices - 08 Nov 2007 21:34 GMT

>Hello,
>
[quoted text clipped - 12 lines]
>
>Thanks in advance,

First thing I would try is a repair. Could be in the uninstall of
200x and install of 2007, something didn't get set right. A
repair will go back and validate the files and settings.

*Click the Microsoft Office Button, and then click Excel Options.
*Click Resources.
*Click Diagnose, click Continue, and then click Start
Diagnostics.

Signature

__________________________________________________________________________________
Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all)
What is on my Pocket PC? http://www.ehansberry.com/
Microsoft MVP - Mobile Devices www.pocketpc.com
What is an MVP? - http://mvp.support.microsoft.com/

Reply to this Message