Excel online - form...
 

MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel

[Closed] Excel online - form controls error message

3 Posts
3 Users
0 Reactions
2,114 Views
Posts: 1106
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 3:22 pm
Posts: 10326
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 3:30 pm
Posts: 1106
Free Member
Topic starter
 

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


 
Posted : 18/02/2022 3: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 6:05 pm