Unfortunately, Excel Online does not allow you to edit macros or form controls directly, only view them. If you need to modify a file that contains macros, follow these steps.
-
Download the spreadsheet with a right click
2. Go to “Downloads” folder in your computer and right click on the spreadsheet. Then select Properties.
3. Select Unblock and run Macros.
4. Once you're done making your changes, don't forget to Upload the file as a New Version in Edi!
Click on the file > Click Versioning in tool bar > Upload New Version > Select edited file from your desktop.
5. You're all set! Now you'll have a clear version history and ensure that all the changes you made in the desktop are reflected in Edi Cloud.