I have an excel template (at work) where we made some modification to some of the sheets.

The template behind has now been modified, and I want to copy some of the master sheets to my modified workbook.

The sheet I want to copy has references to named cells like NPV, etc.

However after copying the sheet, these references does not work. The cell says =NPV but it does not read the value?

Can anyone help?