View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jan Jan is offline
external usenet poster
 
Posts: 159
Default 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