Accessing Add-Ins Tab

[J. B.]

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.

 

[Nick Hodge]

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

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

 

[ilia]

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".

 

[Ed Hansberry, MS-MVP/Mobile Devices]

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,

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.
--
__________________________________________________________________________________
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? -

 

[J. B.]

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