Using Vlookup.

Rows in referring worksheet are set to autofit.

When I make a new entry in the table, the height of the dependant cell in
another worksheet referring to the entry in the table will not expand to
accommodate the height of the new entry. But if I then do some minor thing
while in that cell, like clicking the text colour drop-down the row height
readjusts.

What can I do to make the dependent row height automatically expand when a
new entry is made in the lookup table?
Regards,
Keith