While you can certainly copy and paste data from a network or Web-based external source into Excel, importing ... you can simply refresh your worksheet to update your data as well.

Now, click on the Delete Cached Files option, and again select the Delete Cached Files button when prompted. Once done, relaunch Excel, and check whether the Refresh Recommended message is still ...

You can always get the latest data by tapping the “Refresh data” button within Excel ... If you enter data into an Excel spreadsheet, you’ll be able to create your own custom data types ...