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