ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Display information being cut short (https://www.excelbanter.com/excel-worksheet-functions/257274-display-information-being-cut-short.html)

Frustrated

Display information being cut short
 
I am attempting to display information from another workbook. Now I am able
to get this information displayed and all the information is displayed
correctly, but my problem is when i save and exit the file, then open it back
up it cuts the information in half. Can this be stopped? The current
formula to pull the data from one workbook1 to workbook2 is \[Internet
Sales.xls]Master'!$J$27

Dave Peterson

Display information being cut short
 
Open the sending workbook in the same instance of excel.

When you close the sending, excel and windows will truncate (after a recalc) the
string to 255 characters.



Frustrated wrote:

I am attempting to display information from another workbook. Now I am able
to get this information displayed and all the information is displayed
correctly, but my problem is when i save and exit the file, then open it back
up it cuts the information in half. Can this be stopped? The current
formula to pull the data from one workbook1 to workbook2 is \[Internet
Sales.xls]Master'!$J$27


--

Dave Peterson


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com