Ethernet connection not being picked up when disconnecting from wifi

Download the LAN driver http://download.msi.com/dvr_exe/Killer_network_w10.zip

When you open device manager, do you see a yellow alert on any driver?
On Support For Z97 GAMING 5 | Motherboard - The world leader in motherboard design | MSI USA

Is your BIOS up to date?

running HP assistant will update your drivers and bios if its needed

HP Support Assistant | HP® Official Site

To figure out which network driver your machine has, do:

start > run > msinfo32 > components > problem devices

The results, which windows calls problem devices, are those devices on your machine that do not yet have the correct driver. The results will look something like this (this is from my system):

PCI\VEN_8086&DEV_15B8&SUBSYS_E0001458&REV_00

If you then google the first half of that string plus the word "driver", you'll see what you need. For instance if you google

PCI\VEN_8086&DEV_15B8 driver

the first hit takes you to "Downloads for Intel® 82544EI Gigabit Ethernet Controller" which is my driver.