Denial,
I was given this tip by an exchange student from Europe that I worked with last year. I have no idea how it works, nor did he, but as you can imagine it has been a topic of much debate ever since.
Regard
cmza
The solution that works for me is,
1) Click on the X icon at the top right, as if to close the Excel application - Note: NOT the icon associated with the particular workbook but the one related to Excel itself.
2) When asked "Do you want to save changes to the particular workbook"...