Treeview control problems when upgrading from Excel 2007 to 2010

Question

Yesterday my computer was upgraded from Excel 2007 to Excel 2010 (both 32 bit).

When opening one of my spreadsheet files I get the following message --> "Object library invalid or contains references to object definitions that could not be found".

I have isolated this problem to the treeview control (this error does not occur when I remove this control).

I then tried to re-create the control through "Additional controls..." (found by right clicking the Toolbox) and then drawing it on the Userform within VBE. I could not do this and the following errors occurred as I dropped it onto the Userform:

• Microoft Treeview Control, Version 5.0 (SP2) - comctl32.ocx --> "The control could not be created because it is not properly licensed"
• Microoft Treeview Control, Version 6.0 - mscomctl.ocx --> "Element not found"

Interestingly enough, although I can't drop this treeview control onto a form in the VBE, I can put this control straight on the spreadsheet.

Note that on a colleagues computer, the treeview control had an "(SP6)" at the end and I could drop this control onto the Userform without any problems.

Note also that at home I also have Excel 2010 and this control works on that computer (but this machine is 64 bit / Windows 7).

Thank you for any help you may be able to give me.

Thanks

Ivor

Answer 1

Hi Ivor,

Open up a command prompt and cd into the folder with the OCXs, then for each one (this works for DLLs too):

    regsvr32 "comctl32.ocx"

I hope that proves to be the solution for you.

Cheers

John

Answer 2

We have the same problem.  We are expriencing the issue on both Windows XP and Windows 7 systems.  We realize that we can register the file again,but can you explain why the file is unregistered on upgrade of Office to 2010?

Thanks

Answer 3

Thanks John, but could you explain how to re-register these controls?

Thanks

Ivor

Answer 4

We had exactly the same problem on just one PC.  We fixed it by re-registering those two OCXs (probably only one of the two actually needed it).

Cheers

John