So here's the deal.

I have two workbooks, one is the master workbook and the other is a
linked copy. So when the master workbook is changed, the other gets
automatically updated. Well this works fine and dandy except that some
cells in the master workbook contains strings more than 255 characters.
So when the linked workbook (containg the function (=CLEAN("the cell
from master workbook)) tries to extract that string, it ends up
truncating the characters 255. Is there any way to get around this?
Any input is much appreciated.

Cheers,

IronHell