| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why is a linked cell restricted to 256 characters
I have a linked sheet in excel and the contents of the source sheet. When
this is displayed in the linked sheet, only the first 256 characters are shown. Can any one help |
|
#2
|
|||
|
|||
|
I don't find this to be the case.
I can get around 1000 characters to show in the cell. Excel's specs state that 32,767 chars can be entered but only 1024 will show or can be printed. How many chars in your source cell? Gord Dibben Excel MVP On Mon, 14 Feb 2005 11:25:02 -0800, "Excel help needed" <Excel help wrote: I have a linked sheet in excel and the contents of the source sheet. When this is displayed in the linked sheet, only the first 256 characters are shown. Can any one help |
|
#3
|
|||
|
|||
|
You get all those characters when the "sending" workbook/worksheet is open.
But close that worksheet, recalculate, it gets truncated to 255 (IIRC) characters. == To the Original Poster--I have no idea why the excel developers did it that way. Gord Dibben wrote: I don't find this to be the case. I can get around 1000 characters to show in the cell. Excel's specs state that 32,767 chars can be entered but only 1024 will show or can be printed. How many chars in your source cell? Gord Dibben Excel MVP On Mon, 14 Feb 2005 11:25:02 -0800, "Excel help needed" <Excel help wrote: I have a linked sheet in excel and the contents of the source sheet. When this is displayed in the linked sheet, only the first 256 characters are shown. Can any one help -- Dave Peterson |
|
#4
|
|||
|
|||
|
Dave
Only when the sheet is in another workbook is what you are saying? Gord On Mon, 14 Feb 2005 19:07:48 -0600, Dave Peterson wrote: You get all those characters when the "sending" workbook/worksheet is open. But close that worksheet, recalculate, it gets truncated to 255 (IIRC) characters. == To the Original Poster--I have no idea why the excel developers did it that way. Gord Dibben wrote: I don't find this to be the case. I can get around 1000 characters to show in the cell. Excel's specs state that 32,767 chars can be entered but only 1024 will show or can be printed. How many chars in your source cell? Gord Dibben Excel MVP On Mon, 14 Feb 2005 11:25:02 -0800, "Excel help needed" <Excel help wrote: I have a linked sheet in excel and the contents of the source sheet. When this is displayed in the linked sheet, only the first 256 characters are shown. Can any one help |
|
#5
|
|||
|
|||
|
Yep.
Now I see what you were thinking! Gord Dibben wrote: Dave Only when the sheet is in another workbook is what you are saying? Gord On Mon, 14 Feb 2005 19:07:48 -0600, Dave Peterson wrote: You get all those characters when the "sending" workbook/worksheet is open. But close that worksheet, recalculate, it gets truncated to 255 (IIRC) characters. == To the Original Poster--I have no idea why the excel developers did it that way. Gord Dibben wrote: I don't find this to be the case. I can get around 1000 characters to show in the cell. Excel's specs state that 32,767 chars can be entered but only 1024 will show or can be printed. How many chars in your source cell? Gord Dibben Excel MVP On Mon, 14 Feb 2005 11:25:02 -0800, "Excel help needed" <Excel help wrote: I have a linked sheet in excel and the contents of the source sheet. When this is displayed in the linked sheet, only the first 256 characters are shown. Can any one help -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Footnote wizard linked to cell content | Excel Worksheet Functions | |||
| Copying linked cell references. | Excel Worksheet Functions | |||
| Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions | |||
| Linked cell location of hyperlink | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
