Share via

Excel files in Onedrive changing timestamp when unchanged

Anonymous
2019-11-21T10:53:07+00:00

I have Excel spreadsheets in a OneDrive folder on my office workstation which uses Onedrive for Business (Sharepoint). I have shared the folder with myself at home, where I use Office 365. Here, I have noticed that whenever I open one of these spreadsheets just to look at, making no edits, and not saving it, the timestamp is changed to the current date and time back in my office OneDrive folder.

This is irritating, because we rely on the timestamps of our project spreadsheets reflecting the actual time they were last worked on, not some later time when they were inspected remotely.

How can I prevent OneDrive from updating these timestamps?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

8 answers

Sort by: Most helpful
  1. Anonymous
    2020-05-15T20:06:42+00:00

    The same thing is happening to me.  I thought that turning off "Autosave" would help, but it is still updating my date/time stamps.  And I am simply using OneDrive on my personal computer, although I have set it up on another computer in my home that I occasionally use and I DO want my files to be synced with the cloud.  That's the point of OneDrive, right?

    I checked the setting that pendleswitch posted above and it was not checked.

    Is there some other Autosave setting somewhere that I need to uncheck.  

    Honestly I DO NOT ever use Autosave and I definitely don't want it changing my date/time stamps every time I look at a file.  

    My workaround right now is to copy files I want to look at to a temporary area and then open them there.  But sometimes I forget to do that and I shouldn't have to anyway.

    Can somebody at Microsoft PLEASE fix this or let us know how to turn it off if there is already a way to do that??

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2019-11-21T15:41:27+00:00

    Right, I understand you, in order to turn off "Autosave" feature, Close all your Office files, next, in the little cloud close to Windows time in taskbar, white cloud (Personal), blue cloud (Business), click on it, then Settings > Office tab > and uncheck "Use Office applications to sync Office files that I open", then click "Ok".

    https://support.office.com/en-us/article/use-of...

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2020-03-05T13:10:19+00:00

    CuongTran85: Like rdazarola you are thinking this is something to do with syncing. It is not. Don't forget I am using the files as if they were stand-alone files on my hard drive, by opening a local folder and selecting the Excel file to be opened by the local program.

    I found the answer on someone's blog. It's a simple setting within the Excel program itself. Here is the process for the benefit of others:

    1. Open the Excel program using the system tray icon so that the home screen shows.
    2. Select Options > Save
    3. Uncheck the box there which says "Autosave OneDrive and SharePoint Online files by default on Excel"
    4. Close Excel.

    Here's a screen shot of the option box:

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2020-01-09T11:48:28+00:00

    rdazarola: thanks for reply and my apologies for delay, I have been away.

    Now I tried this unchecking sync process. This does work, but the problem is that it goes too far, in that on the rare occasions when I do have to edit a file remotely, the edit is not reflected in the original file. So I would constantly need to remember to check and uncheck this sync setting all the time, and this is unacceptable.

    I have also been experimenting with the Excel settings. In the top left of my version of Excel there is an autosync setting, which is on by default, and I can switch it off, but it keeps reverting to on again just when I don't need it. I need to change this to off by default in an underlying sort of way. How do I do this?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2019-11-21T15:35:13+00:00

    Thanks rdazarola.

    I am not opening the file directly in the cloud in my OneDrive Business site. I am opening the file locally, using Excel which comes with the paid-for version of Office 365, in a folder which was previously shared to me and is synced using the Onedrive sync app.

    Version history and the check in / check out feature are not relevant to this situation, as both of them refer to reverting edits made, and I have made no edits.

    I think the problem is entirely within Excel. Does the version that I am using have some sort of autosave function that I am not aware of? If so, I need to switch it off, to make it behave normally and only save when I press Ctrl+S.

    Here is the version number:

    Version 1910 (Build 12130.20390)

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments