Why can files in a Windows Server share go back 1-3 days?

Question

Windows

There is a server with Windows Server 2012 R2 installed on it and twenty users working on it remotely via RDP. Users work with the Shared Documents folder, mainly with Excel spreadsheets. All documents are launched as common, work in them is carried out in parallel. The data archiving service is running on the server, which performs a backup of the system disk at night.
Periodically (at different intervals), the same problem occurs - the files are rolled back 1-3 days ago. For example, today employees made changes to the files in the morning, reported, and after 10 minutes they did not find a single change in the files, they rolled back to yesterday evening. And so it was 6-7 times in the last 2 months. I looked through all the logs, but did not find any notifications about rollbacks from the archiving service.
Is it possible to view the rollback history?
PS Perhaps as a second symptom - occasionally there is such a situation when 2 different users open the same file, and one user sees it with changes for today, and the second - only with yesterday's.

Answer 1

1. google: "File system audit", get file change logs. You will begin to understand who saved what and when.
2. Theoretically, there may be problems with offline files.
3. if there are no problems with licensing, look towards SharePoint.

Answer 2

Most likely the situation described by you in PS two users opened the file, one forgot to close, after 1-3 days I remembered about it, saved it and closed it. As a result, the changes made by another user are overwritten.

Answer 3

Most likely the problem is caching on users' computers.
I think it is necessary to exclude in principle the possibility of using the same file by two users for writing - only the owner should have write access. If this does not work out, you need to develop a solution using a database.