Listview on my Windows 11 with Excel 365

[JKwan]

On my Win 11 64bit tablet I am getting this error:

"the subject is not trusted for the specified action"


when I try to add a listview I get this error. If I create a test file with the listview, it disappear from the form. I searched with Google to try to find out how to fix this but not going anywhere with it. Hopefully, someone can help me solve this.

thanks

[JKwan]

well, let me add TreeView has the same problem...... I don't know if it is the MSCOMCTL.OCX problem? I copied the OCX file from my working machine and put it onto the Win 11 machine still same problem! I unregistered and re-register with my new ocx file, still not working.

[Aussiebear]

This is all that I could find.

Primary Causes:


Missing or Corrupt Common Controls Library (MSCOMCTL.OCX): The ListView control is part of the Microsoft Common Controls library. If this file is missing, unregistered, or corrupted, Windows won't trust it. This is the most frequent culprit.
Incorrect Bitness (32-bit vs. 64-bit): While your Windows 11 is 64-bit, Excel 365 can be either 32-bit or 64-bit. If you're trying to use a 32-bit ListView control with a 64-bit version of Excel (or vice-versa), you'll encounter trust issues. It's crucial that the bitness of the control matches the bitness of the Excel application.
Security Settings/Trust Center: Excel's Trust Center settings might be preventing the control from running. This could be due to macros being disabled, untrusted locations, or specific ActiveX settings.

Since you have copied the mscomctl.ocx from one computer to another, are you sure it is the correct bit (32 vs 64)?

[JKwan]

Thanks Aussie, you jogged my poor memory…. I am running 64bit office.
I then did more digging and I found the 64 bit version of mscomctl.ocx but the file won’t register….
I think I am stuck! Anyone have more insight?

[arnelgp]

i don't see any problem on my a2021 x64.
32053320543205532056

[Jan Karel Pieterse]

Microsoft has changed the defaul security setting for activeX controls in Trust center. Change the setting to match this one to get the treeview working again.
32057
Please note that this is now the default setting for Office, so you might consider alternatives like my free all-VBA treeview: https://jkp-ads.com/articles/treeview.aspx

[arnelgp]

I have same setting on my Exel, but like I said, I don't get any error message when using Treeview or Listview.

[Jan Karel Pieterse]

Change the setting to the top one (the new default). That will trigger the message.

[JKwan]

Microsoft has changed the defaul security setting for activeX controls in Trust center. Change the setting to match this one to get the treeview working again.
32057




Thanks, Jan. Really appreciate the help and fixed my problem

As to your Treeview, I used it in the past and it is great! But for my little project, I need Listview.

[JKwan]

I have same setting on my Exel, but like I said, I don't get any error message when using Treeview or Listview.
Thanks for the help, arnelgp!

[Jan Karel Pieterse]

We also have a ListGrid control, but it isn't free I'm afraid: https://jkp-ads.com/articles/treeview.aspx#ProVersion

[JKwan]

Jan:
Thanks for pointing out different controls that you are offering, however, this is a small project for my son. I don't need anything heavy duty.

[Jan Karel Pieterse]

You're welcome! Good luck with that project.