Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup: I have to double click each cell to get correct results?
Hi - users have been using an existing vlookup which worked well - now when
they copy down the formula it retains the previous cell contents until they double click and press enter in each cell which then updates with the correct information?? Can anyone help please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup: I have to double click each cell to get correct results?
ToolsOptionCalculation, check Automatic
-- Kind regards, Niek Otten "gillyd" wrote in message ... Hi - users have been using an existing vlookup which worked well - now when they copy down the formula it retains the previous cell contents until they double click and press enter in each cell which then updates with the correct information?? Can anyone help please? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup: I have to double click each cell to get correct resul
Many thanks Niek - really appreciate it!!
"Niek Otten" wrote: ToolsOptionCalculation, check Automatic -- Kind regards, Niek Otten "gillyd" wrote in message ... Hi - users have been using an existing vlookup which worked well - now when they copy down the formula it retains the previous cell contents until they double click and press enter in each cell which then updates with the correct information?? Can anyone help please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have to double click a cell for the "text" format to take | Excel Discussion (Misc queries) | |||
double click a cell with Date format | Excel Discussion (Misc queries) | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |