linked workbook issue
 

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

linked workbook issue
 

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

linked workbook issue
 

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

linked workbook issue
 

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

linked workbook issue
 

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

linked workbook issue
 

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

linked workbook issue
 

"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