Windows 10: 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.

:)

 

files

OneDrive gets my vote on that. There is a OneDrive app fully supported on Apple as well as word/excel etc.

 

OneDrive files won't stay pinned to taskbar

If a pin an excel files that is saved in my OneDrive folder to the pinned excel files list in the taskbar, once I open that file it disappears from the pinned list. This only happens with files saved in the OneDrive folder. Any files saved in my documents
remain pinned to the taskbar. How can I get the OneDrive files to stay pinned? They stayed pinned before but just started disappearing this last week.

 

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





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

 

Thank you, Kari.

That was exactly what I was looking for.