Did it really work in xl97???

What happens if you close that "sending" workbook, then select the cell with the
long string that's returned and hit F2, enter (just to reevaluate the formula).

(I recall that I had trouble in xl97, too!)



GarryFerg wrote:

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

--

Dave Peterson