Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't see all the text in a cell when using file links
I have never seen this one before. I have a spreadsheet, lets call this A,
that is linked to numerous other spreadsheets on my lan. When I call up spreadsheet A, regardless of whether I update my links or not, the text in the cell containing the link reference is truncated. I am not exceeding any character length constraints here either. I know this because when I open up the linked file B I can see the whole thing. Any ides? We are using Excel 2003. TIA Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't see all the text in a cell when using file links
How many characters are we talking about? How much gets truncated?
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Mark" wrote in message . com... I have never seen this one before. I have a spreadsheet, lets call this A, that is linked to numerous other spreadsheets on my lan. When I call up spreadsheet A, regardless of whether I update my links or not, the text in the cell containing the link reference is truncated. I am not exceeding any character length constraints here either. I know this because when I open up the linked file B I can see the whole thing. Any ides? We are using Excel 2003. TIA Mark |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't see all the text in a cell when using file links
If the sending file is open in the same instance of excel, you'll see all the
characters. If the sending file is not open in that same instance of excel, you'll see 256 characters (well, after the first recalculation). Mark wrote: I have never seen this one before. I have a spreadsheet, lets call this A, that is linked to numerous other spreadsheets on my lan. When I call up spreadsheet A, regardless of whether I update my links or not, the text in the cell containing the link reference is truncated. I am not exceeding any character length constraints here either. I know this because when I open up the linked file B I can see the whole thing. Any ides? We are using Excel 2003. TIA Mark -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't see all the text in a cell when using file links
Thats correct. If the linked file is not open I only see about 256 chars,
but when the linked file is open I see all the text. Is this a bug in Excel? Why can't I see the whole thing whether the linked file is open or closed? Thanks "Dave Peterson" wrote in message ... If the sending file is open in the same instance of excel, you'll see all the characters. If the sending file is not open in that same instance of excel, you'll see 256 characters (well, after the first recalculation). Mark wrote: I have never seen this one before. I have a spreadsheet, lets call this A, that is linked to numerous other spreadsheets on my lan. When I call up spreadsheet A, regardless of whether I update my links or not, the text in the cell containing the link reference is truncated. I am not exceeding any character length constraints here either. I know this because when I open up the linked file B I can see the whole thing. Any ides? We are using Excel 2003. TIA Mark -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't see all the text in a cell when using file links
I think it's a design choice--not a bug.
I don't know away around it. Mark wrote: Thats correct. If the linked file is not open I only see about 256 chars, but when the linked file is open I see all the text. Is this a bug in Excel? Why can't I see the whole thing whether the linked file is open or closed? Thanks "Dave Peterson" wrote in message ... If the sending file is open in the same instance of excel, you'll see all the characters. If the sending file is not open in that same instance of excel, you'll see 256 characters (well, after the first recalculation). Mark wrote: I have never seen this one before. I have a spreadsheet, lets call this A, that is linked to numerous other spreadsheets on my lan. When I call up spreadsheet A, regardless of whether I update my links or not, the text in the cell containing the link reference is truncated. I am not exceeding any character length constraints here either. I know this because when I open up the linked file B I can see the whole thing. Any ides? We are using Excel 2003. TIA Mark -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
Cell export to Text File? | Excel Discussion (Misc queries) | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
How can you import external text file paragraph a into single cell | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) |