$ sign for absolute reference Explanation
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
|