Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character count within a cell | Setting up and Configuration of Excel | |||
Character count within a cell | Setting up and Configuration of Excel | |||
How do I perfom a character count in a single cell in Excel? | New Users to Excel | |||
Excel 2003 -- Character spacing within the same cell | Excel Discussion (Misc queries) | |||
Excel 2003 cell contents truncated when linked into Word? | Links and Linking in Excel |