i have a client that gave me 2 workbooks. 1 has some descriptions in column
b. the other has some formulas that use the descriptions.

so one of their formula might be ='[workbook.xls]sheet'!$B$3

only partial text will populate the cell unless the workbook with the
descriptions is actually loaded. i know it's not a cell length issue, some
of the text is less than 100 characters.

so, it the cell shows partial text, i then load the description workbook,
the cell immediately contains all of the information from B3

anyone know what would cause this? i am thinking it may be some sort of
corruption.
--


Gary

it looks like most stop at 256 characters unless the sheet is loaded into
memory, then the entire contents is displayed from the formula.

does this make sense?

--


Gary


"Gary Keramidas" wrote in message
...

i have a client that gave me 2 workbooks. 1 has some descriptions in
column b. the other has some formulas that use the descriptions.

so one of their formula might be ='[workbook.xls]sheet'!$B$3

only partial text will populate the cell unless the workbook with the
descriptions is actually loaded. i know it's not a cell length issue, some
of the text is less than 100 characters.

so, it the cell shows partial text, i then load the description workbook,
the cell immediately contains all of the information from B3

anyone know what would cause this? i am thinking it may be some sort of
corruption.
--


Gary

could it be that this is somehow affecting the calculation until the sheet
is loaded?
Maximum Column width 255 characters



--


Gary


"Gary Keramidas" wrote in message
...

i have a client that gave me 2 workbooks. 1 has some descriptions in
column b. the other has some formulas that use the descriptions.

so one of their formula might be ='[workbook.xls]sheet'!$B$3

only partial text will populate the cell unless the workbook with the
descriptions is actually loaded. i know it's not a cell length issue, some
of the text is less than 100 characters.

so, it the cell shows partial text, i then load the description workbook,
the cell immediately contains all of the information from B3

anyone know what would cause this? i am thinking it may be some sort of
corruption.
--


Gary

the reference should contain the full path of the description file,
e.g.
='D:\Documents and Settings\vasilis\Desktop\[1.xls]Sheet1'!$C$7

it does, i just didn't list it

--


Gary


wrote in message
oups.com...
the reference should contain the full path of the description file,
e.g.
='D:\Documents and Settings\vasilis\Desktop\[1.xls]Sheet1'!$C$7

Excel will return up to 255 characters from a closed workbook.

If you have a cell in a closed workbook that has less than that and you're not
seeing all of it returned via your formula, make sure the columnwidth/rowheight
is adjusted so you can see more.



Gary Keramidas wrote:

i have a client that gave me 2 workbooks. 1 has some descriptions in column
b. the other has some formulas that use the descriptions.

so one of their formula might be ='[workbook.xls]sheet'!$B$3

only partial text will populate the cell unless the workbook with the
descriptions is actually loaded. i know it's not a cell length issue, some
of the text is less than 100 characters.

so, it the cell shows partial text, i then load the description workbook,
the cell immediately contains all of the information from B3

anyone know what would cause this? i am thinking it may be some sort of
corruption.
--

Gary

--

Dave Peterson

"Excel will return up to 255 characters from a closed workbook."

dave, that's the limitation i needed to know.

--


Gary


"Dave Peterson" wrote in message
...
Excel will return up to 255 characters from a closed workbook.

If you have a cell in a closed workbook that has less than that and you're
not
seeing all of it returned via your formula, make sure the
columnwidth/rowheight
is adjusted so you can see more.



Gary Keramidas wrote:

i have a client that gave me 2 workbooks. 1 has some descriptions in
column
b. the other has some formulas that use the descriptions.

so one of their formula might be ='[workbook.xls]sheet'!$B$3

only partial text will populate the cell unless the workbook with the
descriptions is actually loaded. i know it's not a cell length issue,
some
of the text is less than 100 characters.

so, it the cell shows partial text, i then load the description workbook,
the cell immediately contains all of the information from B3

anyone know what would cause this? i am thinking it may be some sort of
corruption.
--

Gary

--

Dave Peterson