Forum Discussion
Excel Spreadsheet with Code
Do you mean you try to open the file in Microsoft Teams ? Actually it's practically the same as Excel in web which doesn't support VBA.
SergeiBaklan Hello, I created an excel that I put a code so I can when I paste a specfic number it changes what is in the cell to the correct information. It works in excel, when I upload it to teams it doesnt work.
To be sure
- you have macro enabled Excel file saved on local drive, when open in Desktop app macro works
- you upload the file on Microsoft Teams (aka on SharePoint)
- from Microsoft Teams you open the file in Desktop Excel app, and now macro doesn't work
Correct?
- Correct. I found some information on different ways to try to upload but I haven't been able to get it to work.
Candace305
Strange for me. If you keep the file on SharePoint, or on SharePoint through Teams interface, and open it in desktop app - macro shall work.
- Correct!