I have a workwheet that is using a lookup table. Everything works fine
except when I update (change) the data in the lookup table. I have confirmed
the location of the lookup table but just does not want to update the data in
the worksheet.

The help command tells me to use the refresh data command, however it seems
to have disappeared. Also won't just closing out the file and reopening it
update the data"