Link cell reference to another file.

[BlueDingo]

Hello Mr Excellers,
I have come across a problem linking a cell reference from a 'source' Excel file to another 'destination' Exel file.
It only picks up the first 255 characters unless I open up the source file at the same time as when the destination file is open.
I have checked if there is a limitation through 'Data, Validation', no problems there.
Just wondering why it cuts short the text mid word...at 255 characters.

I'm using Excell 2003.

Thank you.

 

[drsarao]

Microsoft does agree to 255 limit here:http://office.microsoft.com/en-us/e...age-links-to-other-workbooks-HA001054812.aspx

Linking to cells containing large amounts of data

Links can only return the first 255 characters in a cell. If you want to link to large amounts of data, first distribute it among several cells on the source worksheet. If you're linking to a cell with contents that will grow as you maintain the source workbook, keep the 255-character limit in mind.

But this seems to apply ONLY when source book is closed in Excel 2003. (Strange and inexplicable) Once you open the source book, all the characters get pulled.
No such limitation is there in Excel 2007. (There is of course a final limit of max 32767 characters in a cell)