G
Guest
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
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