Display information being cut short

F

Frustrated

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
 
D

Dave Peterson

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.


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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Need to Keeping Same Display Value on 2 Workbooks 1
Display information from other worksheet 1
Formulas do not update 2
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Object Browser in VBA 0
Hyperlinks 0
Best way to display Mulitple comboboxes and dropdown boxes for a userform 0

Top