Thread: vlookup doesn't update / recalculate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default vlookup doesn't update / recalculate
Look he

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"kfell" wrote in message ...
|I have a cell containing a VLookup that doesn't contain the correct value
| If I click on the cell and then click to edit the function and push enter it
| updates to show the correct value.
| How can I get a macro to force the cells to update so they show the correct
| value?


Reply With QuoteReply With Quote