MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP function not recalculating


Posted by Eric on January 02, 2001 11:08 AM

I am having trouble with the vlookup function not recalculating when the source data table is updated. I have calculation on automatic. The wierd thing is that when you hit F2 to edit the formula and the <enter> it updates. It is a big file and I cannot go through and do this every time an update is needed or worry that the file is wrong and not recalculated correctly


Posted by Dave on January 02, 2001 11:52 AM


Hi Eric

Have a look at this link and see if any fit
http://search.support.microsoft.com/kb/psssearch.asp?SPR=xlw97&T=B&KT=ALL&T1=7d&LQ=Formulas+not+recalculating&S=F&A=T&DU=C&FR=0&D=xlvba97%2Bor%2Bxlgeneralkb%2Bor%2Bxl97kb%2Bor%2Bvbapps%2Bor%2Boleapps%2Bor%2Bofficekb%2Bor%2Boffice%2Bor%2BOffDev%2Bor%2Bodbc%2Bor%2Bexcelkb&LPR=%22Excel+97%22&LNG=ENG&VR=http%3A%2F%2Fsupport.microsoft.com%2Fsupport%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fservicedesks%2Fwebcasts%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fhighlights&CAT=Support&VRL=ENG&SA=GN&Go.x=40&Go.y=23

#7 looks promising.

Dave


OzGrid Business Applications