please give an example of the equation
when you paste
are you in edit mode in the cell?
or do you just have the cell selected?

"pano" wrote:

On Feb 15, 12:08 am, "David Biddulph" wrote:
Nothing to do with the $ sign, but check Tools/ Options/ Calculation, and
make sure it's set to Automatic, nor Manual.
--
David Biddulph

"pano" wrote in message

oups.com...



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- Hide quoted text -

- Show quoted text -

Interesting just checked and it is set on automatic

Thanks for your reply
Steve