Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
$ 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
$ 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
$ 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
$ 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute Reference | Excel Discussion (Misc queries) | |||
Absolute Reference | Excel Worksheet Functions | |||
absolute reference | Excel Discussion (Misc queries) | |||
Explanation Relative/Absolute Cell Reference | Excel Worksheet Functions | |||
absolute reference | Excel Discussion (Misc queries) |