Why is a linked cell restricted to 256 characters

G

Guest

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
 
G

Gord Dibben

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Autocomplete text/string within a single cell, between different worksheets 1
Trimming a cell down to 256 Characters 2
Cannot copy cell 5
Macro to remove characters 5
Excel 2003, Linked Spreadsheet, Cell Character Count 3
cells linked from worksheet to worksheet 1
When I add a row to my source sheet, it doesn't update my linked . 2
How to filter list if hyperlink happen 8

Top