Prev: Print Excel files from a BAT file.
Next: Pivot Table date format
From: JimR on 14 Jan 2010 09:30
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
From: Dave Peterson on 14 Jan 2010 10:41
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
From: Dave Peterson on 14 Jan 2010 10:48
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
From: trip_to_tokyo on 14 Jan 2010 11:07
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
 | 
Pages: 1
Prev: Print Excel files from a BAT file.
Next: Pivot Table date format