Sharepoint and Excel Spreadsheets with VBA's / Macros etc

[Dazzybeeguy]

I have a spreadsheet that has a lot of macros & buttons etc within it.

Would all this functionally be available if a user accesses the file via a sharepoint site ?

 

[severynm]

It depends on how the file is opened. Given that the file is saved in SharePoint, if it is opened with the desktop app then yes, but if it is opened in Teams or the Web browser then no.

If your macros open or close other files or do things with your file system, you'll need to take a few additional steps to make sure these work, but if you don't do any of that then no extra changes would be necessary.

 

[Dazzybeeguy]

It depends on how the file is opened. Given that the file is saved in SharePoint, if it is opened with the desktop app then yes, but if it is opened in Teams or the Web browser then no.

If your macros open or close other files or do things with your file system, you'll need to take a few additional steps to make sure these work, but if you don't do any of that then no extra changes would be necessary.

thank you for the response, can more than one person amend and save in an excel file hosted on SharePoint and if so is this only if it’s not opened with the desktop app?

 

[severynm]

Yes. By multiple people can access and edit a file at the same time (this is called Co-Authoring) and is available no matter how the document is opened or accessed, even with the desktop app.