M
Mikeice
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
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