Excel 2003, Linked Spreadsheet, Cell Character Count
 

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,
--
C. B. Hague
Orlando, Fl

Excel 2003, Linked Spreadsheet, Cell Character Count
 

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.

--
Kevin Backmann


"Chuck Hague" wrote:

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,
--
C. B. Hague
Orlando, Fl

Excel 2003, Linked Spreadsheet, Cell Character Count
 

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.

Chuck Hague wrote:

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,
--
C. B. Hague
Orlando, Fl

--

Dave Peterson

Excel 2003, Linked Spreadsheet, Cell Character Count
 

Thanks Dave,

Much appreciate your sharing

C. B. Hague
Orlando, Fl


"Dave Peterson" wrote:

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.

Chuck Hague wrote:

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,
--
C. B. Hague
Orlando, Fl

--

Dave Peterson