1

SharePoint 2013 on premise is not always saving changes in Excel to the point that some colleagues are losing hours of work. Why does this keep happening?

May I add, that the drafts can be see in Office Upload Center, but even these drafts do not have the latest changes. Please guide me.

Improve this question
2
  • As a side note, they should use auto-save in Excel and set it to save e.g. every 15 minutes, then they won't lose hours of work. There's no excuse for them being lazy and not using auto-save.
    – Tally
    Commented Jul 22, 2019 at 10:20
  • please explain how to set autosave up for excel in sharepoint on premise
    – Saz Mifsud
    Commented Jul 22, 2019 at 10:30

1 Answer 1

Reset to default
0

Take a look at this MS link on Excel autosave. Your IT department might be able to enforce this centrally as a group policy.

One other thing, when users save an existing file, they can check in Sharepoint to see that the Modified Date has changed. After saving a new file in to Sharepoint, they can also refresh the page in Sharepoint to see if the file appears - if their file does not show up in Sharepoint then the save has not been committed correctly.

autosave

Improve this answer
3
  • Tally, is this also valid for SharePoint on Premise?
    – Saz Mifsud
    Commented Jul 22, 2019 at 13:30
  • I use Sharepoint 2013 on Premise, which is the same version as yours. So yes it is valid. Did you look in Excel yet?
    – Tally
    Commented Jul 22, 2019 at 13:35
  • I did, and I tried it out, but I see no drafts being saved..
    – Saz Mifsud
    Commented Jul 22, 2019 at 13:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.