vlookup issues

i created a workbook using excel 2016. when using it on 2007 the vlookup functions do not automatically fill after filling in the drop down choices. i have to save the sheet then reopoen it for everything to populate it. all calculations are set for automatic and i checked compatibility and found no issus. something i missed?