Forum Discussion
Excel files stuck at "Saving"
Have a sharepoint in testing mode and when some testers and even myself open a file (we are set to where it automatically opens in excel and not the web version), make changes and click on the save i...
We see this all the time in Excel with a SharePoint document library synchronised using OneDrive. Despite the time, the whole Office->OneDrive->SharePoint system is flaky.
Get the same issue, particularly using excel. Difficult to ask users to keep an eye on the "saving" status, when the whole idea of onedrive is for seemless syncing.
- Our issue is that for some reason the auto save and one drive / SharePoint were conflicting so we had to disable the auto save for the files. Since Auto Save is an excel option and not an actual file option we had to think outside the box and with the help of multiple help sites, etc we were able to get the below to work on the workbook_open() under "ThisWorkbook" in VBA...
Dim AutoSv As Boolean
If Val(Application.Version) > 15 Then
AutoSv = ActiveWorkbook.AutoSaveOn
'MsgBox "AutoSave set to: " & AutoSv
If AutoSv Then ActiveWorkbook.AutoSaveOn = False
AutoSv = ActiveWorkbook.AutoSaveOn
'MsgBox "AutoSave now set to: " & AutoSv
End If
By doing this, we found that when they went to save we did not see the issue and did not require each person to go into excel and change auto save to no as a default. Hope this helps....
This is only a small snipit from the code as we also disabled the "Save As" and key strokes to avoid users from downloading or save as to local drives to avoid multiple copies of files floating around. Needed them to be able to update so could not do read only and due to the VBA needed them to open in actual excel and not the web version (would not run VBA). Overall, had to learn a decent amount of coding but our particular process went rather well.We also have the same issue. Is there any way of getting microsoft to respond to this. I imagine 50% of the sharepoint-excel-mapped-sharepoint-drive-community have had similar massive frustrations with this issue AOSPWB
