link to workbook but only returns 255 Characters

[Cage]

When I link to a cell in a closed workbook using the formula:

= 'C:\temp\[text.xls]sheet1'!$A$1

It only returns the first 255 characters in that cell. However it I open the workbook I am linked to, then it returns the all of the characters. Therefore my question is is it possible to return all of the characters in a cell of a closed workbook without having to open the workbook?.

thanks

Cage

 

[TonyJollans]

Hi Cage,

I don't believe it is possible, but am happy to be corrected.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[combo]

Cage, Tony,

the limit 255 chars was in older (up to 95?) excel versions, it still exists in some cases in newer ones. The size of data in a cell linked to a closed workbook is an example. Similarly, when you open two instances of excel and copy long cell contents between them, the target data is truncated. And probably there are more such oddities.

combo