I assume your workbook has a worksheet named "Sales", same as the original
workbook name. When you rename the workbook it will still include the
worksheet named "Sales", and the Name will continue to refer to it.

If you rename the worksheet the Name should automatically update.


You are absolutely correct and I should have known that is the reason. I appreciate your help, Peter.