How to get network data in Excel 2007

2. At this time, the "New Web Query" dialog box pops up, you can type the address of the web page you want to add data in the "Address" column, and click the Go button.

<>4. Click the yellow arrow next to the table you want to select, you can see that the yellow arrow changes to a green check mark after clicking, which means that the content has been selected, and then click the "Import" button.

5. The "Import Data" dialog box pops up, and click "OK" when the settings are completed.

6. After the data acquisition is completed, all the previously selected web page content will be imported into the excel worksheet.

To be honest, I hate Excel developers who use macros to do things at every turn, and it's a very simple question, why use macros for such complex things? You know how to macro does not mean that others are able to macro, my suggestion is to use hyperlinks directly. Simple and practical.

And the steps are not very many.

First, open the Excel 2007 worksheet, click on the location where you want to import the data, and then find the fifth item in the menu bar"data", click, find "From" under "Get External Data" and click on it.

The New Web Query dialog box pops up, and you can type the address of the web page to which you want to add data in the Address field.

Click the yellow arrow next to the table you want to select, you can see that the yellow arrow changes to a green check mark after clicking, which means that the content has been selected, and then click "Import (i)".

The "Import Data" dialog box pops up, and click "OK" when the settings are completed.

"Retrieving data...... is displayed in the excel sheet”

The data is obtained, and all the previously selected web pages are imported into the excel sheet.

1.First, open the Excel 2007 worksheet, click on the location where you want to import the data, and then find the fifth item in the menu bar"data", click, find "From" under "Get External Data" and click on it.

2.The New Web Query dialog box pops up, and you can type the address of the web page to which you want to add data in the Address field.

3.Click the yellow arrow next to the table you want to select, you can see that the yellow arrow changes to a green check mark after clicking, which means that the content has been selected, and then click "Import (i)".

4.The "Import Data" dialog box pops up, and click "OK" when the settings are completed.

The table says "Retrieving data......”

In addition to fetching data from the local machine, we can also import data from the network to Excel and keep it updated with the network.

Connect the computer to the network, open Excel, execute the "Data Import External Data New Web Query" command, open the "New Web Query" dialog box, enter the corresponding ** into the "Address" bar, press the "Go" button to establish a connection with the network.

Check the area that needs to be imported and press the "Import" button, and the data will be imported into Excel.

When you open the corresponding workbook document in the future, the system will automatically update the data, remember to make sure that the computer is connected to the network.

excel2010 - Data Tab - Get External Data Option Group - Self Button.