Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If yes then display information in cell | Excel Worksheet Functions | |||
Display information from other worksheet | Excel Worksheet Functions | |||
Display last status information | Excel Worksheet Functions | |||
How do I export information from FileMaker and still display zero. | Excel Discussion (Misc queries) | |||
Display references to linked information | Excel Worksheet Functions |