If a cell is linked to a cell on another worksheet the following appears in
the bar at the top of the page

=sheet10!D5

Is there any way of eliminating =sheet10!D5 from the bar once the data is in
the new cell.

Many Thanks