| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why would a vlookup function stop working in excel 2003?
The Vlookup was working fine - and then it stopped working completely. Is
there a refresh or something in the naming of the list? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why would a vlookup function stop working in excel 2003?
When you say 'stopped working', what do mean? Does it not calculate at all,
or does it just show and error (#N/A)? -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Patti" wrote: The Vlookup was working fine - and then it stopped working completely. Is there a refresh or something in the naming of the list? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why would a vlookup function stop working in excel 2003?
If it worked once, it should work twice.... unless....
Your workbook may have gotten set to Manual calculation mode. This can happen if you open a workbook set that way and later open other workbooks during the same session. You mentioned refreshing the naming of the list. I have seen Excel lose track of named ranges in the past (older versions of Excel as 97, but not lately). It may have done that. Try changing the formula to use the actual addresses of the upper left/lower right cells of the table instead of the name you gave the range and see if that helps. Also, you can use Insert | Names to find the name of the table and see if it still points to the proper range. "Patti" wrote: The Vlookup was working fine - and then it stopped working completely. Is there a refresh or something in the naming of the list? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why would a vlookup function stop working in excel 2003?
Calculation mode was accidentally change to "manual"?
ToolsOptionsCalculation. Set it to "automatic" Gord Dibben MS Excel MVP On Thu, 30 Apr 2009 10:21:03 -0700, Patti wrote: The Vlookup was working fine - and then it stopped working completely. Is there a refresh or something in the naming of the list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What can I do if all Microsoft 2003 office products stop working? | Excel Discussion (Misc queries) | |||
| Why did the goal seek function stop working? | Excel Discussion (Misc queries) | |||
| My Excel stop working can any one help? | Setting up and Configuration of Excel | |||
| excel 2003 right-click function not working | Excel Worksheet Functions | |||
| CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
