| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Character limit when retrieving indirect text from external sheet
I have a results workbook that uses a VLOOKUP function to return text from
another source workbook. As long as the source workbook is open then the formula works correctly, but if it is closed then the returned text is truncated to 255 characters. Open the source workbook again and the text magically reappears... etc. I suspect this is a 'feature' of Excel 2003 but is there any workaround available? Thanks TM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in formular bar doesn't all show (is there a character limit. | Excel Discussion (Misc queries) | |||
| How to modify the web link for retrieving data from external sourc | Excel Worksheet Functions | |||
| Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ? | Excel Discussion (Misc queries) | |||
| Text box character limit | Excel Discussion (Misc queries) | |||
| Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) | |||
Threaded Mode
