Re: Why is a linked cell restricted to 256 characters

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 02/15/05 

Date: Mon, 14 Feb 2005 19:07:48 -0600

You get all those characters when the "sending" workbook/work*** is open.

But close that work***, 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
> needed@discussions.microsoft.com> wrote:
>
> >I have a linked *** in excel and the contents of the source ***. When
> >this is displayed in the linked ***, only the first 256 characters are
> >shown. Can any one help 

-- 
Dave Peterson
Quantcast