| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Cells
I have linked two worksheets from different workbooks and I noticed that when
I enter text into a cell, only a portion of the text appears in the worksheet linked to it. Have I missed a critical setting or is there a small limit to the amount of text I can use? -- JimR |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked Cells
If the sending workbook is closed, then the receiving cell in the open workbook
will only show 256 characters. If you open the sending workbook (and recalc if necessary), you'll see the long strings. JimR wrote: I have linked two worksheets from different workbooks and I noticed that when I enter text into a cell, only a portion of the text appears in the worksheet linked to it. Have I missed a critical setting or is there a small limit to the amount of text I can use? -- JimR -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked Cells
Make that 255 characters...
Dave Peterson wrote: If the sending workbook is closed, then the receiving cell in the open workbook will only show 256 characters. If you open the sending workbook (and recalc if necessary), you'll see the long strings. JimR wrote: I have linked two worksheets from different workbooks and I noticed that when I enter text into a cell, only a portion of the text appears in the worksheet linked to it. Have I missed a critical setting or is there a small limit to the amount of text I can use? -- JimR -- Dave Peterson -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked Cells
Have you tried making the column wider?
If my comment has helped please hit Yes. Thanks. "JimR" wrote: I have linked two worksheets from different workbooks and I noticed that when I enter text into a cell, only a portion of the text appears in the worksheet linked to it. Have I missed a critical setting or is there a small limit to the amount of text I can use? -- JimR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
| Linked cells | Excel Worksheet Functions | |||
| Linked Cells | Excel Discussion (Misc queries) | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
