ActiveX Box Crashes in Teams

[St Jimmy]

Hi all,

I made a spreadsheet that you select reports using an ActiveX comboBox.

It works fine in desktop, when I load it to Teams to share with my company it constantly corrupts sheet1 (where ActiveX box is) and the logo changes in Dev mode (highlighted yellow):

It seems to not be able to be stored in Teams. The goal is NOT to launch from teams but rather launch from Desktop Excel within teams.

As I was retesting, this error apparently fixed itself. It now works fine, I 'think' it pulled the old workbook (same name as the new one) the first time I saved it. IDK.

But this has happened a few times before and will likely happen again. Has anyone seen this behavior?
Does anyone know what the icon change Sheet1 means?
Clues of what I'm doing that's corrupting the sheet to guide me in the future are MUCH appreciated!

Thank you!
Kyle

 

[St Jimmy]

This behavior happened again after 2 days. Any insights on to why the ActiveX boxes are corrupting the workbook when it's stored in Teams?

Thanks!

 

[jkpieterse]

ActiveX controls on sheets are notoriously unreliable. Perhaps it helps to delete them and recreate them?

 

[St Jimmy]

ActiveX controls on sheets are notoriously unreliable. Perhaps it helps to delete them and recreate them?

Thank you! It's not what I was hoping to hear, but I can appreciate it.
Do you think it would just be better to redo with a form box? Or would a 'fresh' activeX box

Does anyone know the events that most often cause this ActiveX corruption behavior?

Thanks! I know Im asking for speculation, but I've used ActiveX before with its quirks but never had this much consistent corruption (once a year vs once a week (until I involved teams).

 

[jkpieterse]

I would start by replacing them and see if it helps.

 

[St Jimmy]

I would start by replacing them and see if it helps.

Thanks! After some wrestling with Microsoft I realized that Sharepoint was storing a copy of the corrupt file in recycle bin and for reasons unknown would revert to this file when I renamed the fixed file.

So, for example:
FileName.xls is corrupt in teams and I deleted it.
FileName2.xls is not corrupt and uploaded to teams. It works.
Rename FileName2.xls to FileName.xls and it is corrupt upon open.
Rename FileName.xls back to FileName2.xls and it works.
Say a few curse words.
Open Sharepoint and find the FileName.xls is in Recycle Bin (Teams does not have Recycle Bin but is driven off Sharepoint).
Delete FileName.xls from Sharepoint Recycle Bin.
Rename FileName2.xls to FileName.xls.
So far working.

Thank you for your help! It got me thinking outside the code box
Hopefully the explanation above might help some Google Searchers in the future!