Treeview control problem when upgrading to Excel 2010

[ihorwitz]

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 at home I also have Excel 2010 and this control works on that computer (but this machine is 64 bit).

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

Thanks
Ivor