Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Formula to reference name of sheet tab | Excel Discussion (Misc queries) |