reference to other sheet doesnt work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jan - 21 Aug 2006 20:32 GMT

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

Reply to this Message

jan - 21 Aug 2006 20:42 GMT

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
>
[quoted text clipped - 8 lines]
>
> regards

Reply to this Message

Elkar - 21 Aug 2006 20:48 GMT

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

> Sorry, the Excel is XP version with SP3.
> Acctually this doesnt work:
[quoted text clipped - 21 lines]
> >
> > regards

Reply to this Message

Paul B - 21 Aug 2006 20:42 GMT

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.

Signature

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

> sheet 1: Sheet1. Cellcontent A2=1
>
[quoted text clipped - 8 lines]
>
> regards

Reply to this Message