Hi,
If you have the $ sign on a reference Sheet1!$A$1 where you paste
a link into another sheet, why does it sometimes not show the data
from the link and you need to press enter over the cell again for it
to work????

Stephen