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.

Thank you, Kari.

That was exactly what I was looking for.