In cooperation with Experts Exchange.
When you need the data in a table always to be current, you don’t have to keep copying and pasting from the source over and over. Use the “Get and Transform Data” section in the Data tab to connect to live data on the Web. FYI, you’ll no longer see the features called “PowerQuery” in Excel. That was the name of an add-in that is now built into the application.