ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   $ sign for absolute reference Explanation (https://www.excelbanter.com/excel-worksheet-functions/130691-%24-sign-absolute-reference-explanation.html)

pano

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


David Biddulph

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




pano

$ 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


bj

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




All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com