If a new unsaved file you will get the dialog to enter a name.
If an existing saved file, Save will do that save without asking you for a
name since it assumes you want to save the file with same name.
To change name of a saved file, hit "Save As"
Gord Dibben MS Excel MVP