•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel with VBA code in SharePoint not working
Our take
When moving an Excel file with VBA code to SharePoint, users often encounter issues with the code not functioning in the web version of Excel. This limitation arises because Excel for the web does not support VBA. However, syncing the file with OneDrive allows for VBA functionality on the desktop version. It's essential to consider that when multiple users edit the Excel file simultaneously, syncing can become problematic, potentially leading to conflicts.
I have an excel file which has some vba code, I have moved to file to SharePoint but when I open that file, the VBA code part is not working - this is excel in web. I have synced to file on OneDrive, here when I open the excel in desktop, the VBA code part is working well. I have a question if multiple users update that excel at the same time, will it sync properly? if not what can be done? because I have se en sync issues sometimes with OneDrive and SharePoint.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#no-code spreadsheet solutions#rows.com#financial modeling with spreadsheets#real-time data collaboration#real-time collaboration#Excel#VBA code#SharePoint#OneDrive#Excel in web#sync issues#multiple users#code execution#desktop version#user collaboration#file synchronization#file transfer