To automatically update stock prices in Excel, you can use the "Data" tab in Excel and select the "From Web" option. From there, you can enter the URL of the webpage that contains the stock prices you want to track. Excel will automatically import the data from the webpage and refresh it at regular intervals. Another option is to use APIs or plugins available in the market that allow you to directly import live data into Excel.