| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Links w/in same workbook not working
Windows XP Excel 2002
I have links referring to different cells in a different worksheet but the same workbook. After using the workbook many times, now my links all show "='worksheetname'!A12" instead of giving me what is actually in the cell. Relinking does not work. F2 does not work. It's nothing do do w/ my options. Any suggestions? |
|
#2
|
|||
|
|||
|
Has the number format of your cells somehow gotten changed to Text format?
Check Format, Cells, Number. Francis http://www.theexceladdict.com "JenR" wrote: Windows XP Excel 2002 I have links referring to different cells in a different worksheet but the same workbook. After using the workbook many times, now my links all show "='worksheetname'!A12" instead of giving me what is actually in the cell. Relinking does not work. F2 does not work. It's nothing do do w/ my options. Any suggestions? |
|
#3
|
|||
|
|||
|
The formatting is not the problem. The links are actually to another cell w/
a word in it, not a number. But all the possible formats give me the same problem. Thanks for your fast response. "JenR" wrote: Windows XP Excel 2002 I have links referring to different cells in a different worksheet but the same workbook. After using the workbook many times, now my links all show "='worksheetname'!A12" instead of giving me what is actually in the cell. Relinking does not work. F2 does not work. It's nothing do do w/ my options. Any suggestions? |
|
#4
|
|||
|
|||
|
JenR
It may have something to do with your options. If all formulas are showing.......... Hit CTRL + `(above TAB key) to toggle formula view on/off. Gord Dibben Excel MVP On Thu, 20 Jan 2005 12:11:05 -0800, "Francis Hayes (The Excel Addict)" wrote: Has the number format of your cells somehow gotten changed to Text format? Check Format, Cells, Number. Francis http://www.theexceladdict.com "JenR" wrote: Windows XP Excel 2002 I have links referring to different cells in a different worksheet but the same workbook. After using the workbook many times, now my links all show "='worksheetname'!A12" instead of giving me what is actually in the cell. Relinking does not work. F2 does not work. It's nothing do do w/ my options. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating links to new workbook with same format | Links and Linking in Excel | |||
| View Workbook Links | Excel Discussion (Misc queries) | |||
| Why aren't links between tabs in same workbook automatically updat | Excel Discussion (Misc queries) | |||
| Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) | |||
| Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
