| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel links problem
I have a workbook in which the data in one sheet is linked to the data in
another using a formula like ='Sheet1'!A1. The source cell contains text and I want the same text to appear in the linked cell. Instead of seeing the text in the destination cell I see instead the formula. Calculation is set to automatic and pressing F9 makes no difference. What do I need to do to see the linked text instead of the formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel links problem
Probably the linked-to cell has become formatted as TEXT. Reformat it for
GENERAL, and all should be well........... Vaya con Dios, Chuck, CABGx3 "Wikegolfa" wrote: I have a workbook in which the data in one sheet is linked to the data in another using a formula like ='Sheet1'!A1. The source cell contains text and I want the same text to appear in the linked cell. Instead of seeing the text in the destination cell I see instead the formula. Calculation is set to automatic and pressing F9 makes no difference. What do I need to do to see the linked text instead of the formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel links problem
You are right, the cell was formatted as text and changing the formatting to
general solves the problem. Many thanks "CLR" wrote: Probably the linked-to cell has become formatted as TEXT. Reformat it for GENERAL, and all should be well........... Vaya con Dios, Chuck, CABGx3 "Wikegolfa" wrote: I have a workbook in which the data in one sheet is linked to the data in another using a formula like ='Sheet1'!A1. The source cell contains text and I want the same text to appear in the linked cell. Instead of seeing the text in the destination cell I see instead the formula. Calculation is set to automatic and pressing F9 makes no difference. What do I need to do to see the linked text instead of the formula? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel links problem
You're welcome...........thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "Wikegolfa" wrote: You are right, the cell was formatted as text and changing the formatting to general solves the problem. Many thanks "CLR" wrote: Probably the linked-to cell has become formatted as TEXT. Reformat it for GENERAL, and all should be well........... Vaya con Dios, Chuck, CABGx3 "Wikegolfa" wrote: I have a workbook in which the data in one sheet is linked to the data in another using a formula like ='Sheet1'!A1. The source cell contains text and I want the same text to appear in the linked cell. Instead of seeing the text in the destination cell I see instead the formula. Calculation is set to automatic and pressing F9 makes no difference. What do I need to do to see the linked text instead of the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 automatically redirects links - Linking Problem #2!! | Links and Linking in Excel | |||
| Problem opening excel file with links | Excel Discussion (Misc queries) | |||
| strange problem with links updates in excel | Excel Discussion (Misc queries) | |||
| Problem with updating links in Excel 2003 | Excel Worksheet Functions | |||
| Problem with updating links in Excel 2003 | Excel Worksheet Functions | |||
Linear Mode
