Forum menu
Excel online - form...
 

[Closed] Excel online - form controls error message

Posts: 1110
Free Member
Topic starter
 

I'm getting the following error message on an excel form which I've uploaded to a SharePoint based website. The message appears where form buttons controls should be:

"Excel for the web does not support running or interacting with form controls. To use form controls open this file with the desktop app."

I then get this message when trying desktop app instead:
"Excel cannot open file because the file format or extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Any suggestions re possible solutions?

Thanks


 
Posted : 18/02/2022 4:22 pm
Posts: 10334
Full Member
 

Yep.ย  Opening some excel filesย  online breaks them, it's horrible.ย  My only solution has been to go back to the file that I originally uploaded.ย  At a minimum the web version doesn't run vba but some formulae don't work either


 
Posted : 18/02/2022 4:30 pm
Posts: 1110
Free Member
Topic starter
 

Thanks it's got a fair bit of VBA added.


 
Posted : 18/02/2022 4:44 pm
Posts: 13594
Free Member
 

Huge omission not supporting VBA in the web version - it was their main Office automation language for 15 years or more....


 
Posted : 18/02/2022 7:05 pm