View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default character limit for linking files

If you open the sending workbook, then you'll see that the formula returns the
whole string.

With the sending workbook closed, you'll only see 255 characters.

I don't know any other way around it.

Guruwanabe wrote:

Is there a limit to the number of characters that can be linked from one file
to another? Currently, it truncates the data. Please advise.


--

Dave Peterson