Closing Variations

[Bob]

I typically close a workbook by selecting the "X" on the
upper right hand corner of the window and then saving
changes. When I do this all is well and my changes are
saved.

When someone else closes the file via the pull down menu
by selecting File, close and then saves changes, the
changes are not all saved.

What is the difference? Is there a macro that can make all
closing consistent? Looking for input, thanks

 

[Dave Peterson]

This is not the way excel behaves. I don't think that there's a difference
between these two methods.

Maybe one is forgetting to answer "yes" to the "do you want to save" prompt.

Or maybe one is saving to a different drive/folder.