 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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
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
Thanks it's got a fair bit of VBA added.
Huge omission not supporting VBA in the web version - it was their main Office automation language for 15 years or more....