| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Format Issue
I have two worksheets: We will call them Data and Result. On the result
worksheet I have been linking back to the data worksheet for some data. Now all of the sudden on row one hundred any time I try and link back to the other worksheet I get the linked formula displayig on the computer screen. Why or more important how do I get it off the screen... NOTE: CTRL+~ key did not remove it off my screen... -- GS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link Format Issue
Sounds like the cell was pre-formatted a s Text.
Change to General then F2 and Enter Gord Dibben MS Excel MVP On Wed, 4 Mar 2009 09:29:02 -0800, Gary F Shelton wrote: I have two worksheets: We will call them Data and Result. On the result worksheet I have been linking back to the data worksheet for some data. Now all of the sudden on row one hundred any time I try and link back to the other worksheet I get the linked formula displayig on the computer screen. Why or more important how do I get it off the screen... NOTE: CTRL+~ key did not remove it off my screen... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link Format Issue
Thank you ... Your solution solved my problem
-- GS "Gord Dibben" wrote: Sounds like the cell was pre-formatted a s Text. Change to General then F2 and Enter Gord Dibben MS Excel MVP On Wed, 4 Mar 2009 09:29:02 -0800, Gary F Shelton wrote: I have two worksheets: We will call them Data and Result. On the result worksheet I have been linking back to the data worksheet for some data. Now all of the sudden on row one hundred any time I try and link back to the other worksheet I get the linked formula displayig on the computer screen. Why or more important how do I get it off the screen... NOTE: CTRL+~ key did not remove it off my screen... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link issue | Excel Discussion (Misc queries) | |||
| Issue link Excel 2003 | Excel Discussion (Misc queries) | |||
| Cancel opening messages/phantom link issue | Excel Discussion (Misc queries) | |||
| Excel 2007 Macro/Link Issue (apologies for cross-posting) | Links and Linking in Excel | |||
| Format Issue | Excel Worksheet Functions | |||
Linear Mode
