Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002 VLOOKUP in another workbook returns #VALUE
Excel 2002 VLOOKUP in another workbook returns #VALUE if the workbook is
closed. I have the full path and file name in the formula, but it only populates correctly if I open the "looked up" workbook. Is this a Excel 2002 bug, or is there a way around it? My work around for now is to open the workbook, but set my macro to: Application.ScreenUpdating = False |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002 VLOOKUP in another workbook returns #VALUE
No solution, just a comment: I ran into the same thing at a recent
engagement; I'm not sure whether they were using 2003 or 2007 but it sure wasn't 2002. Therefore I don't think it was a bug. It didn't always work like that, only for external spreadsheets that resided in certain places. I didn't spend a lot of time working on it, for in my case I pretty much had to open the other spreadsheet anyway so it didn't inconvenience me much. But I had a theory, at the time, that the references that worked correctly were to documents that were on my own hard drive and home directory, and in the cases where I had to open the external document to get the references to work, they resided on a different drive shared by my department and others. So I always figured it had to do with the document location. But as I said I never got around to testing my theory. --- "EXCELDEV" wrote: Excel 2002 VLOOKUP in another workbook returns #VALUE if the workbook is closed. I have the full path and file name in the formula, but it only populates correctly if I open the "looked up" workbook. Is this a Excel 2002 bug, or is there a way around it? My work around for now is to open the workbook, but set my macro to: Application.ScreenUpdating = False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Can I convert #N/A to 0 in the VLOOKUP( ) formula ? | Excel Discussion (Misc queries) | |||
Excel 2002: Vlookup formula not working | Excel Discussion (Misc queries) | |||
Excel 2002 VLOOKUP Weird | Excel Worksheet Functions | |||
Vlookup on excel 2002 version | Excel Discussion (Misc queries) | |||
Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Excel Worksheet Functions |