Hi guys

I need to know why this is happening????

I have a closed workbook called 'data.xls'

I have another workbook called 'rep score.xls'

In rep score I have cells linked to the closed workbook data.

Some of these cells have up to 900 char of text.
For some reason I can copy and paste but when I use the link:
='K:\[Data.xls]Sheet1'!B$8
It truncates the text.

How can I get around this.

I used links as the data workbook is constantly being updated.

Please help


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=394161