If you don't plan on using that link any more. You can click on the cell with
the link. Right click...click copy....right click again....click paste
special.... choose values. This will change the cell to the true value that
is showing up in the cell and you will see it in the bar.

HTH, B.

"zephyr" wrote:

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