| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Cell Reference
I am trying Office 2007 and in Excel I have at one attempt tried to reference
a cell in another sheet in the same workbook and another time have attempted to reference a cell from another workbook. In both cases it only shows the formula of the typed in reference, such as =Sheet5!A$1$ and the other was showing something like; ='[Sales Master.xls]Sheet1'!$A$5 It is not showing what exists in the actual cells that I want it to. Any help or ideas?? Thanks JT |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Cell Reference
Jer wrote:
I am trying Office 2007 and in Excel I have at one attempt tried to reference a cell in another sheet in the same workbook and another time have attempted to reference a cell from another workbook. In both cases it only shows the formula of the typed in reference, such as =Sheet5!A$1$ and the other was showing something like; ='[Sales Master.xls]Sheet1'!$A$5 It is not showing what exists in the actual cells that I want it to. Any help or ideas?? Thanks JT Your cell is probably formatted as Text. Try changing the format to General, then click the cell, press F2 as if to edit, and hit Enter. Does that fix it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting cell reference in excel through VBA | Excel Worksheet Functions | |||
| Excel cell reference. | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Hybrid Mode
