Request help linking data 
Author Message
 Request help linking data

OS 9.1, Office 2001-Excel
I want to have the contents of a cell in Worksheet B to change as the
contents of a cell in Worksheet A change.  The data in Worksheet A is a
calculated number.  My husband (he uses Excel on a PC) said to do this:
In Worksheet B, select the cell and enter =;  then go to Worksheet A and
select the cell that contains the calculated entry; then go back to
Worksheet B and press Enter.  It doesn't work -- I get a totally
different number--one that's not calculated and in a different format
even (happens to be $$).  Husband says the data in Worksheet A doesn't
have to be from the same column as data in Worksheet B.

FWIW, the Columns in Worksheet B go: A, F, G----> (note no B, C, D, or
E).  Is that my problem somehow?  I think when I created Worksheet B, I
copied and pasted everything from Worksheet A into a new worksheet and
then deleted some of the columns individually.  Probably rearranged them
for Worksheet B, too.  Is that my trouble?  TIA.
--
-Barb, Mother Superior, Holy Order of the Sacred Sisters of
St. Pectina of Jella (HOSSSPoJ)
<www.jamlady.eboard.com>  State Fair pix added 8/22/02



Thu, 17 Feb 2005 01:40:25 GMT  
 Request help linking data
Melba's Jammin' wrote :

Quote:
> OS 9.1, Office 2001-Excel

OK

Quote:
> I want to have the contents of a cell in Worksheet B to change
> as the contents of a cell in Worksheet A change. The data in
> Worksheet A is a calculated number.

It shouldn't matter.

Quote:
> My husband (he uses Excel on a PC) said to do this:
> In Worksheet B, select the cell and enter =;  then go to Worksheet
> A and select the cell that contains the calculated entry; then go
> back to Worksheet B and press Enter.

I must say he's right, that's how it *sould* work.

Quote:
> It doesn't work -- I get a totally
> different number--one that's not calculated and in a different
> format even (happens to be $$).

What can you read in the cell from the edit field ? It *should* read
something like this: =SheetA!B3

-- let's suppose you want to copy the value of cell B3, but it can be any
other cell, of course --

Quote:
> Husband says the data in Worksheet A doesn't
> have to be from the same column as data in Worksheet B.

I'm afraid he's right again :-)

Quote:
> FWIW, the Columns in Worksheet B go: A, F, G----> (note no B, C, D,
> or E).  Is that my problem somehow?

I don't think it is...

Quote:
> I think when I created Worksheet B, I copied and pasted everything
> from Worksheet A into a new worksheet and then deleted some
> of the columns individually.  Probably rearranged them
> for Worksheet B, too.  Is that my trouble?

I don't think it is.

I think I'd need some more information about it.

All I can say is that I noticed that under *some circumstances* (protected
sheets ?) Excel:2001 behaves surprisingly (Excel 98 didn't) when entering
links the above indicated way. It sometimes only indicates the name of the
sheet, but not the cells. Sometimes, it adds a cell from the 'destination'
sheet to the list of cells, thus making the result false. It's often easier
in this cases to type the link directly as it should appear in the cell (ie
"=SheetA!B3" - without the quotes -) But I couldn't say if this is related
to the problem you describe.

Did this bring you any clue ?

--
Bernard Rey - Toulouse



Thu, 17 Feb 2005 04:04:18 GMT  
 Request help linking data

Quote:

> Melba's Jammin' wrote :

> > OS 9.1, Office 2001-Excel

> OK

> > I want to have the contents of a cell in Worksheet B to change
> > as the contents of a cell in Worksheet A change. The data in
> > Worksheet A is a calculated number.

> It shouldn't matter.

> > My husband (he uses Excel on a PC) said to do this:
> > In Worksheet B, select the cell and enter =;  then go to Worksheet
> > A and select the cell that contains the calculated entry; then go
> > back to Worksheet B and press Enter.

> I must say he's right, that's how it *sould* work.

> > It doesn't work -- I get a totally
> > different number--one that's not calculated and in a different
> > format even (happens to be $$).

> What can you read in the cell from the edit field ? It *should* read
> something like this: =SheetA!B3

Here's what it's in the cell before I press Enter:

='Name of Worksheet A'!K2+'Name of Worksheet B'!K2

- Show quoted text -

Quote:

> -- let's suppose you want to copy the value of cell B3, but it can be any
> other cell, of course --

> > Husband says the data in Worksheet A doesn't
> > have to be from the same column as data in Worksheet B.

> I'm afraid he's right again :-)

> > FWIW, the Columns in Worksheet B go: A, F, G----> (note no B, C, D,
> > or E).  Is that my problem somehow?

> I don't think it is...

> > I think when I created Worksheet B, I copied and pasted everything
> > from Worksheet A into a new worksheet and then deleted some
> > of the columns individually.  Probably rearranged them
> > for Worksheet B, too.  Is that my trouble?

> I don't think it is.

> I think I'd need some more information about it.

Such as?

Quote:

> All I can say is that I noticed that under *some circumstances*
> (protected sheets ?) Excel:2001 behaves surprisingly (Excel 98
> didn't) when entering links the above indicated way. It sometimes
> only indicates the name of the sheet, but not the cells. Sometimes,
> it adds a cell from the 'destination' sheet to the list of cells,
> thus making the result false. It's often easier in this cases to type
> the link directly as it should appear in the cell (ie "=SheetA!B3" -
> without the quotes -) But I couldn't say if this is related to the
> problem you describe.

I'll give it a try.  (Gotta tend a screaming granddaughter right now!)

Quote:

> Did this bring you any clue ?

Thanks for the help.  I'll be back!
--
-Barb, Mother Superior, Holy Order of the Sacred Sisters of
St. Pectina of Jella (HOSSSPoJ)
<www.jamlady.eboard.com>  State Fair pix added 8/22/02


Thu, 17 Feb 2005 06:29:18 GMT  
 Request help linking data

Quote:
> Here's what it's in the cell before I press Enter:
> ='Name of Worksheet A'!K2+'Name of Worksheet B'!K2

That's probably related to the Mac's version ability to automatically add
cell references when clicking (Windows version change the reference
instead).

I suspect your're clicking on the 'Name of Worksheet B' tab after having
clicked on the cell on the first worksheet: in your description, you mention
it ("then go back to Worksheet B and press Enter"). Don't "go back to
Worksheet B", just press the Enter Key. It'll bring you back to Worksheet B
and write the expected cell reference. Well, it should...

You can even test it, just clicking on the tabs : as long as you don"t click
in a cell, but just click on the tabs, you'll see the formula toggle from
"='Name of Worksheet A'!" to "='Name of Worksheet B'!" and bock. But once
you have clicked in a cell, you'll see cell references being added endlessly
and obtain something like "='Name of Worksheet A'!A1+'Name of Worksheet
B'!A1+'Name of Worksheet A'!A1+'Name of Worksheet B'!A1" and so on.

Well I guess there's nothing to do about it !

Let's hope this will help you through it -- as to the screaming grand
daughter, I've got no clue :-)

--
Bernard Rey - Toulouse

Melba's Jammin' wrote :

Quote:


>> Melba's Jammin' wrote :

>>> OS 9.1, Office 2001-Excel

>> OK

>>> I want to have the contents of a cell in Worksheet B to change
>>> as the contents of a cell in Worksheet A change. The data in
>>> Worksheet A is a calculated number.

>> It shouldn't matter.

>>> My husband (he uses Excel on a PC) said to do this:
>>> In Worksheet B, select the cell and enter =;  then go to Worksheet
>>> A and select the cell that contains the calculated entry; then go
>>> back to Worksheet B and press Enter.

>> I must say he's right, that's how it *sould* work.

>>> It doesn't work -- I get a totally
>>> different number--one that's not calculated and in a different
>>> format even (happens to be $$).

>> What can you read in the cell from the edit field ? It *should* read
>> something like this: =SheetA!B3

> Here's what it's in the cell before I press Enter:

> ='Name of Worksheet A'!K2+'Name of Worksheet B'!K2

>> -- let's suppose you want to copy the value of cell B3, but it can be any
>> other cell, of course --

>>> Husband says the data in Worksheet A doesn't
>>> have to be from the same column as data in Worksheet B.

>> I'm afraid he's right again :-)

>>> FWIW, the Columns in Worksheet B go: A, F, G----> (note no B, C, D,
>>> or E).  Is that my problem somehow?

>> I don't think it is...

>>> I think when I created Worksheet B, I copied and pasted everything
>>> from Worksheet A into a new worksheet and then deleted some
>>> of the columns individually.  Probably rearranged them
>>> for Worksheet B, too.  Is that my trouble?

>> I don't think it is.

>> I think I'd need some more information about it.

> Such as?

>> All I can say is that I noticed that under *some circumstances*
>> (protected sheets ?) Excel:2001 behaves surprisingly (Excel 98
>> didn't) when entering links the above indicated way. It sometimes
>> only indicates the name of the sheet, but not the cells. Sometimes,
>> it adds a cell from the 'destination' sheet to the list of cells,
>> thus making the result false. It's often easier in this cases to type
>> the link directly as it should appear in the cell (ie "=SheetA!B3" -
>> without the quotes -) But I couldn't say if this is related to the
>> problem you describe.

> I'll give it a try.  (Gotta tend a screaming granddaughter right now!)

>> Did this bring you any clue ?

> Thanks for the help.  I'll be back!



Thu, 17 Feb 2005 17:12:13 GMT  
 Request help linking data

Quote:

> > Here's what it's in the cell before I press Enter:

> > ='Name of Worksheet A'!K2+'Name of Worksheet B'!K2

> That's probably related to the Mac's version ability to automatically
> add cell references when clicking (Windows version change the
> reference instead).

> I suspect your're clicking on the 'Name of Worksheet B' tab after
> having clicked on the cell on the first worksheet: in your
> description, you mention it ("then go back to Worksheet B and press
> Enter").

Sure was.

 Don't "go back to Worksheet B", just press the Enter Key.

Quote:
> It'll bring you back to Worksheet B and write the expected cell
> reference. Well, it should...

Fly with me to Casablanca, Bernard!!  We'll eat toast and my
prize-winning jam and have Blue Ribbon Brownies later with coffee or
milk!!  Thank you very much!   I'm set.

Quote:

> You can even test it, just clicking on the tabs : as long as you
> don"t click in a cell, but just click on the tabs, you'll see the
> formula toggle from "='Name of Worksheet A'!" to "='Name of Worksheet
> B'!" and bock. But once you have clicked in a cell, you'll see cell
> references being added endlessly and obtain something like "='Name of
> Worksheet A'!A1+'Name of Worksheet B'!A1+'Name of Worksheet
> A'!A1+'Name of Worksheet B'!A1" and so on.

> Well I guess there's nothing to do about it !

> Let's hope this will help you through it -- as to the screaming grand
> daughter, I've got no clue :-)

Who in Hades knows what sets them off!?  All's well with her now.  Good
thing she's cute!!
Thanks again.
--
-Barb, Mother Superior, Holy Order of the Sacred Sisters of
St. Pectina of Jella (HOSSSPoJ)
<www.jamlady.eboard.com>  State Fair pix added 8/22/02


Fri, 18 Feb 2005 03:35:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Help Request: Linking Sheets

2. Request for help transfering data between sheets

3. Help request:Save data to sub-form

4. Request for Help: Data Entry Form Acc97

5. Request for Help: Data Entry Form Acc97

6. URGENT HELP REQUESTED - Query cuts off memo data

7. Request help sorting with Office 2k Web Components PivotTable and OLAP Data Source

8. requesting data from nonexistant data

9. Setting Defaults in Form HELP HELP HELP 3rd request

10. Help Needed - 2nd request - anybody help please


 
Powered by phpBB® Forum Software © phpBB Group