linking cells in Excel 2003. How to not truncate to 255 characters.
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
|