Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 14th 07, 01:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 84
Default $ 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   Report Post  
Old February 14th 07, 02:08 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 620
Default $ 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   Report Post  
Old February 14th 07, 02:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 84
Default $ 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   Report Post  
Old February 14th 07, 04:28 PM posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,397
Default $ 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Absolute Reference Rebecca Excel Discussion (Misc queries) 4 August 30th 06 01:36 PM
Absolute Reference Alain Excel Worksheet Functions 3 July 14th 05 04:53 PM
absolute reference Dano Excel Discussion (Misc queries) 2 May 13th 05 03:33 PM
Explanation Relative/Absolute Cell Reference Cath Excel Worksheet Functions 1 March 6th 05 05:10 AM
absolute reference Dano Excel Discussion (Misc queries) 1 February 25th 05 10:28 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017