Thanks for your response.

1. The cell was formatted as text, but that didn't seem to influence as
other, successful, links were formatted either text or general. In any case,
I amended the range to general but it had no impact.

2. Tried both CTRL + ~, and CTRL + ` (grave accent)(as indicated in Excel
Help-Display or hide formulas). Neither had an impact.

HELP!!

"Gary''s Student" wrote:

Several things to check:

1. make sure the display mode is for results, CNTRL+~ will toggle this
2. make sure the cell with the link was not formatted as text
--
Gary''s Student - gsnu200714


"Twishlist" wrote:

Can anyone offer an explanation for why a link to another workbook might
display the file path, rather than the content of the cell. Withni the same
worksheet and with links to the same other worksheet, some work and some
don't.