listview won't load in 32 bit Excel on 64 bit win7 - ...not available on this machine

[Cyclops]

Excel 2010

"Could not load an object because it's not available on this machine" is the full error message.

But it's not true. It most certainly is available. I can add the listview control to the toolbox. If I try to add it to the form that already has one that isn't displaying due to the error, I get an error. If I create a new file I can add the listview without any problems.

I am definitely using the 32 bit version of excel so, from what I can tell it should work.

http://office.microsoft.com/en-au/su...102840825.aspx

The link above shows that the listview should work on 32 bit versions.

I tried regsvr32 shown below but it didn't work. The \syswow commands worked ok but the \system32 commands errored out. Couldn't load resource or something.

It still doesn't work after regsvr.

http://support.microsoft.com/kb/2748410

Tried running as administrator. Doesn't work, get the error "there was a problem sending the command to the program".

Tried saving the file after closing the error boxes. I was able to re-open the newly saved file without any errors but the listviews still wouldn't load. I could then add new listviews but the existing ones wouldn't display.


I know the easy answer (not easy to implement though) is to use listbox instead but I probably have 20 different listviews in this file alone and who knows how many more in other files. From what I can tell, this should work so I'm hoping there's something that can be done.

I'm sure that I've run old scripts with listviews on win7 computers without any problems. We actually have a couple here that don't have this problem but two new computers today both have the problem.

[Cyclops]

It seems that my computer needs many updates. Windows update shows 107 at 500 MB or so. I thought I was told that the updates were installed already but maybe I misunderstood.

Running them now but at 500 meg, it will take a while to download. Hopefully that will fix things.

[Cyclops]

After updating everything appears to work properly. My apologies for anyone what wasted their time reading this thread.

At least I guess for me it made me aware that using listviews might not be the best way to go. I fear that some of the features I use in the listviews will be hard to recreate using listboxes.

What about treeviews? Are they going away too?

Arggh...

[Izandol]

Treeview and Listview are from same library - Windows Common Controls - and will each have same problems.

[Cyclops]

Treeview and Listview are from same library - Windows Common Controls - and will each have same problems.

I was afraid of that.

Thanks.