Excel 07

P

Patt

Whenever I open Excel, I get a run-time error 2147467259 (80004005) Method
'Add' of object 'CommandBarControls' failed.

What should I do to fix this?

Any help very much appreciated.
 
B

Beth Melton

Based on your description I'd say there is a third-party add-in attempting
to modify your command bars (toolbars/menu bar) which no longer exist in
Excel 2007. The solution to the problem is to find the add-in and disable it
so it no longer attempts to run when Excel starts. First check your XLStart
folder (there might be two of them, one in your profile and one in the
installation path) and see if you find any files. If found, move them out of
the folder and then try starting Excel. If that's not it then click the
Office Button, click Excel Options, then click Add-ins. Scan the Add-ins
list and see which add-ins are active and note the type. Then at the bottom
of the dialog box use the Manage button to display the respective dialog box
(the Add-in type). Try disabling those you think might be the culprit and
then restart Excel.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 

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

Top