Links w/in same workbook not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Linking workbooks together 1
change links to a different source in the same workbook 2
Sharing workbooks limitations - Merged Cells 12
Links only work with both workbooks open... 2
Linking 4
Excel workbook links 1
break link to email workbook 1

Back
Top