Forum Discussion
my xlsm spreadsheet will not work correctly on Office 365
I created a spreadsheet using VBA, so I had to save my file as an xlsm. When I uploaded it to OneDrive, it shows , but the functions don't work (ie drop down list , that lets you select multiple op...
Excel online / Excel in a browser window do not support macros. You can do most everything else in the workbook but macros will not run and activeX and other such controls will not work. You can create drop down lists using data validation and that will work online but those are NOT multiselection. If it must work online you need to re-factor how you are going to do things. There are scripts but those must get activated and have different functionality than macros so depends on what you need as to if they will even do it.