Receiving system error in Excell 2007

D

deconinckg

A client is receiving this error "system Error &H80004005(-2147467259)" in
excel 2007 when opening a new file or an exisiting file.

This error came up after visio 2003 was uninstalled and visio 2007 got
installed on his system.

This error can be a lot, and I looked a bit around where they say it might
be something with memory. But then I wonder why he never gave this error
before untill visio 2007 got installed.

Any help is welcome and I would be very thankfull to those who can help me
in this issue.

Greetz
 
P

Paul

deconinckg,

I have had this problem but not specifically with Visio.

It may be there is a bit of Vb coding in the Personal.xls which which uses
"early binding" to the Visio, specifically Visio 2003. Open the VBE and
select the Personal.xls in the Project window, then select Tools>References
.. Among the boxes checked, is there one "Microsoft Visio 11.0 Object
Library" followed by the words "IS MISSING"? If so, uncheck the box and go
down the list and find "Microsoft Visio 12.0 Object Library" and check that
box , press OK and save the workbook. That may solve your problem.
Whilst you are in the VBE have a look at any custom Add-ins that are loaded.
Do any interface with Visio, if so try unloading them from Tools> Add-ins...
in the main window. Add-ins are usually password protected so you cannot
see their References; though good programmers would normally use "late
binding", as they have no way of knowing which version of a program will be
on a computer.

(I am assuming Visio 2003 is version 11).

I have also run detect and repair (Help>Detect and repair..) on Excel which
solved the problem; but you'll need the installation disks.

If that does not work then uninstall both and re-install. That should solve
it.

Paul
 

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