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
|