No you cannot turn them off. To make the names work the same as previously, prepend each name with the @ character:
=@Sales-@Cost
The @ character forces Excel to use a feature you've been using without knowing called implicit intersection. It takes the value from the name on the same row (or column).
Alternatively, you can use =Sales-Cost in the top-left cell only and it'll fill all by itself.
