Excel and OneDrive Solved

  1.    12 Mar 2018 #1

    Excel and OneDrive

    For years I have kept my Excel files on one of my local drives but now I am trying to put them out on OneDrive and am running into a problem.

    When I use one of the locally stored files and make a change to it that I don't want to keep if I try to exit it I get a message asking if I want to save it. Sometimes I do and others I do not.

    However, If I open one of the OneDrive files and make some changes those changes are reflected in file when I exit.

    How can I make the 'OneDrive' files behave like the locally stored files and ask me if I want to save them?

    Thanks for any help.
      My ComputerSystem Spec

  2. Kari's Avatar
    Posts : 15,250
    Windows 10 Pro
       13 Mar 2018 #2

    Turn AutoSave off (top left corner), screenshot from Excel 2016:

    Click image for larger version. 

Name:	image.png 
Views:	15 
Size:	24.8 KB 
ID:	180733

    Excel will now prompt to save or discard changes, also for files on OneDrive.

      My ComputerSystem Spec

  3.    13 Mar 2018 #3

    Thank you, Kari.

    That was exactly what I was looking for.
      My ComputerSystem Spec

  4. Kari's Avatar
    Posts : 15,250
    Windows 10 Pro
       13 Mar 2018 #4

    You are welcome!
      My ComputerSystem Spec


Related Threads
I just purchased Office 365 Premium for my family with 5 1T accounts, original intention was to automatically sync all pictures and videos from family (2 parents + 2 kids) iPhones and Android phones to one OneDrive account. 5th account is for family...
Now that my free 200 GB OneDrive offer is ending I have to decide between base, 50GB, Office 365 Home or alternative sync storage. Any guidance would be appreciated. I have desktop+laptop Windows computers. Same live.com e-mail for all. Other...
Office Online is a collection of free web based applications available to all Microsoft email account users (outlook.com, live.com, hotmail.com, msn.com). It offers basic versions of Microsoft's Office suite of desktop applications. Signing in to...
Network & Sharing Add or Remove Shared Folders from OneDrive in Tutorials
How to Add or Remove Shared Folders from Your OneDrive You can easily save your files to OneDrive and get to them from any device, like your Windows 10 PC, Windows 10 tablet, or Windows 10 Mobile phone. You can use OneDrive to share photos,...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 02:54.
Find Us