Microsoft Office Tutorials and References
In Depth Information
Importing External Data
the Home tab to format them and add the requisite AutoFilter buttons (see
Chapter 3 for details). When formatting data as a table, you remove all
external connections to the data on the website.
You can make web queries only when your computer has Internet access.
Therefore, if you’re using Excel 2013 on a portable device that can’t currently
connect to the web, you won’t be able to perform a new web query until
you’re in a place where you can connect.