Can anyone tell me why...

Audiojoe · Apr 11th, 2002, 01:49 AM

I am trying to link two sheets together by putting = in one cell then clicking on the one I want to link to. Thing is, I am typing = then going to the other sheet and it wont let me click on a cell. In fact, when I move the cursor over the cells in the book I want to link to, the cursor changes to that little finger pointer. Yet when I am not trying to link to the cell the cursor is the normal arrow one.

Can anoyone tell me why this is?

Orbit121 · Apr 11th, 2002, 01:51 AM

3-d cell reference?
if thats what we are talking about

throw in the = sign in the cell you want to link

click on the worksheet you want the info from
dont worry about the cursor type
just click on the cell you want, it should be in dotted lines
press enter
and it should be done

if we arnt talking about 3-d cell refernce can you be more specific

Audiojoe · Apr 11th, 2002, 02:00 AM

Yeah I know how to do that, it just won't click on the cell, you can't select the one I want to link to. There is no protection on or anything like that either

digit · Apr 25th, 2002, 04:12 PM

I had exactly this problem and spent hours trying to resolve it. By accident I found that simply scrolling down made the "hand" disappear and I was able to reference cells on the second sheet.

No idea why this happened though.

Jack in the UK · Apr 25th, 2002, 04:15 PM

hi my old mate Audiojoe

didi the system prior crash, give error 1004 or some old rubbish but some bit about VXD error?

poss BSD showed (what some call blue screen - i do not call it this but...)

Apr 25th, 2002, 04:15 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	hi my old mate Audiojoe didi the system prior crash, give error 1004 or some old rubbish but some bit about VXD error? poss BSD showed (what some call blue screen - i do not call it this but...) __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 01:49 AM	#1
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I am trying to link two sheets together by putting = in one cell then clicking on the one I want to link to. Thing is, I am typing = then going to the other sheet and it wont let me click on a cell. In fact, when I move the cursor over the cells in the book I want to link to, the cursor changes to that little finger pointer. Yet when I am not trying to link to the cell the cursor is the normal arrow one. Can anoyone tell me why this is?

Apr 11th, 2002, 01:51 AM	#2
Orbit121 New Member Join Date: Apr 2002 Posts: 3	3-d cell reference? if thats what we are talking about throw in the = sign in the cell you want to link click on the worksheet you want the info from dont worry about the cursor type just click on the cell you want, it should be in dotted lines press enter and it should be done if we arnt talking about 3-d cell refernce can you be more specific

Apr 11th, 2002, 02:00 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Yeah I know how to do that, it just won't click on the cell, you can't select the one I want to link to. There is no protection on or anything like that either

Apr 25th, 2002, 04:12 PM	#4
digit New Member Join Date: Apr 2002 Posts: 1	I had exactly this problem and spent hours trying to resolve it. By accident I found that simply scrolling down made the "hand" disappear and I was able to reference cells on the second sheet. No idea why this happened though.