Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Microsoft Excel displays all cell references by default. When you click on a cell, its column and row references are highlighted in the worksheet's column and row headings.

How Do I Reference a Cell in Another Worksheet in Excel?. Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects.