Excel 2007 problem

[don]

Can anyone help?

I recently installed Excel 2007 (as part of Office 2007 installation) on a
Vista platform and everything worked fine - although still trying to
understand what happened to some of the previously cherished commands that I
used in Excel. However, after installing further software, I now get the
following message whenever I open Excel:

Microsoft Visual Basic run-time error: '-2147467259 (80004005)'
Method 'Add ' of object 'CommandBarControls' failed.

If I hit the end button at the end of this message Excel then seems to
function OK - but I then will get the message the next time I open Excel.
This is rather annoying and worrying - and the message is totally
meaningless to me.

Do I need to uninstall and re-install Office 2007/Excel 2007?
Any help much appreciated.

 

[Bernard Liengme]

Sounds like a macro is trying to run. Do you have a PERSONAL workbook in the
XLSTART folder?
If so, temporarily rename it PERSONAL.OLD and see what happens
I would suggest you ask this question in one of the Microsoft Excel
newsgroups (where the are more Excel experts.

Try this site to help you locate familiar XL2003 commands in XL2007
http://office.microsoft.com/en-us/excel/HA101491511033.aspx
best wishes

 

[don]

Bernard - many thanks for taking the time to reply. I actually found the
solution to my problem using Google which revealed the following web page.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1609140&SiteID=1
This described my problem exactly and the explanation provided there allowed
me to solve the problem immediately - which made me very happy (not having
to reinstall or get into anything beyond my technical capability!)

Also thanks for your link to the site showing how to locate the Excel 2007
equivalents to Excel 2003 commands. In general this is very helpful -
however, I still couldn't find one really useful command that is in Excel
2003 and earlier versions. In previous versions of Excel, a chart window
could be displayed using the "Chart Window" command on the View menu (this
command only appears in those earlier versions of Excel when you are
pointing at a chart). I now find (again through Google) that the
Microsoft developers in their infinite wisdom have removed this extremely
useful command (which I have used continuously for many years) without
mentioning this in the standard Excel 2007 info - or on the site that you
linked me to. It is very frustrating to buy the latest product and feel
that it has taken a very substantial backward step! The developers also
list other "Deprecated Features For Charting'" in a blog at
http://blogs.msdn.com/excel/archive/2006/08/28/724641.aspx and provide an
explanation of the technical reasons that have driven them to exclude the
command at
http://technet2.microsoft.com/Offic...01b1-4d17-90ca-d43735a7382a1033.mspx?mfr=true