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"...