Prev: Create a formula in a worksheet that links two other worksheets
Next: Find cell value within table
From: Frustrated on 24 Feb 2010 10:45
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
From: Dave Peterson on 24 Feb 2010 10:52
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
 | 
Pages: 1
Prev: Create a formula in a worksheet that links two other worksheets
Next: Find cell value within table