ExcelBanter - character limit for linking files

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - character limit for linking files (https://www.excelbanter.com/excel-worksheet-functions/106779-character-limit-linking-files.html)

Guruwanabe

character limit for linking files

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

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

All times are GMT +1. The time now is 06:06 AM.