Hi
this shouldn't work in Excel 97 as well. AFAIK no workaround exist for
this

--
Regards
Frank Kabel
Frankfurt, Germany

"GarryFerg" schrieb im
Newsbeitrag ...
We have 2 Excel workbooks. One ( workbook 1 ) has some cells which
derive
their contents by linking to cells in another workbook ( workbook
2 ).
"Updating" populates workbook 2's cells but only with the first 255
characters of each cell. Unfortunately we have many cells containing
more
than 255 chars.
A link might look like:
='\\Ravel\spower\tmp\gfer\[Allstate Problem List.xls]Closed
Problems'!$K147

We do have a sort of work round if the link does not have a pathname
but
I think it should work as it is or I should have found ref to this
limitation by now !
It works in Excel 97 !!! Any help much appreciated. Garry Ferguson