Hi,
Unless you have made some sort of changes to Book 1 you will not be prompted
to save it.
You are never prompted to save one workbook when you save another - Unless
you are closing Excel as a means of saving a workbook. If so, that is not
the way to save a file, just choose File, Save or click the Close button for
the file (not the Close button for Excel).