Excel 2003, Linked Spreadsheet, Cell Character Count

  • Thread starter Thread starter Chuck Hague
  • Start date Start date
C

Chuck Hague

Currently use Excell 2003 - SP2, to document weekly status reports from about
a dozen team mates. The consolidating spreadsheet, with links to all the
others, will only display the first 255 characters of a linked cell. Report
spreadsheets (data entry point) display 2 or 3 times that many characters
without ptoblem.

Is the 255 characters for "linked cells" an absolute limit or is there a way
to display more characters in a cell linked to another spreadsheet.

(Note: all spreadsheets stored in the same folder on a network file server)

Thanks in advance for sharing your experiences,
 
255 is the maximum width of a column and I don't know of a limit of 255
placed on linked cells. As far as the display of data is concerned, Excel
limits the number of characters per cell to a maximum of 32,737, however, it
will only display the first 1,024 characters.

As long as there's is nothing to the right of you cell, you should see a
maximum of 1,024 characters per cell, linked or not.
 
Excel will only bring back 255 characters from a closed workbook.

If you open the "sending" workbook (and recalc), then you'll see all the
characters.

That's the way excel works.
 
Thanks Dave,

Much appreciate your sharing

C. B. Hague
Orlando, Fl


Dave Peterson said:
Excel will only bring back 255 characters from a closed workbook.

If you open the "sending" workbook (and recalc), then you'll see all the
characters.

That's the way excel works.
Click to expand...
 
Back
Top