reference to other sheet doesnt work
 

sheet 1: Sheet1. Cellcontent A2=1

sheet 2:

Try to write this:
=Sheet1!A2

Sadly, only the reference text shows up.

Any help on this one? Thank You

regards

reference to other sheet doesnt work
 

Sorry, the Excel is XP version with SP3.
Acctually this doesnt work:

Sheet2: E180 contains a text or a number.

Writing =Sheet2!E180 in a cell in sheet1 doesnt work.

The referencetext are just shown in cell, not the number/text from sheet2.

regards








jan skrev:

sheet 1: Sheet1. Cellcontent A2=1

sheet 2:

Try to write this:
=Sheet1!A2

Sadly, only the reference text shows up.

Any help on this one? Thank You

regards

reference to other sheet doesnt work
 

Jan, is the cell in sheet to formatted as text? this will cause your
formula to show up, format the cell to something else and try it again.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"jan" wrote in message
...
sheet 1: Sheet1. Cellcontent A2=1

sheet 2:

Try to write this:
=Sheet1!A2

Sadly, only the reference text shows up.

Any help on this one? Thank You

regards

reference to other sheet doesnt work
 

Sounds like the cell the formula is in is formatted as Text. Try changing
the cell format to "General" then re-enter the formula.

HTH,
Elkar


"jan" wrote:

Sorry, the Excel is XP version with SP3.
Acctually this doesnt work:

Sheet2: E180 contains a text or a number.

Writing =Sheet2!E180 in a cell in sheet1 doesnt work.

The referencetext are just shown in cell, not the number/text from sheet2.

regards








jan skrev:

sheet 1: Sheet1. Cellcontent A2=1

sheet 2:

Try to write this:
=Sheet1!A2

Sadly, only the reference text shows up.

Any help on this one? Thank You

regards