Solution to errors in Excel importing external data in Win7 system

What is the most commonly used software in our normal office? Of course, the Office software in the Word document, execl form and PPT, when the need to use text when we choose Word, in the digital statistics with EXECL, when the presentation of the picture using PPT, these three kinds of office software is common. But recently, there are Win7 users who say that when importing external data with Excel, there is always an error and cannot be imported successfully, which not only damages the external data, but also affects our office efficiency. The following small series to teach you a trick, how to import external data in the Win7 system computer.

The solution for errors in Excel importing external data in Win7 system is as follows:

1. First of all, we need to double hit the Excel form program in our Win7 flagship computer, and then we click the arrow in the Name box on the formula bar, which is the area where the external data is imported.

2. Completed the above steps we also selected the area to import data, next we find the top of the "Data" option, click the "Connect" button below.

3. In the Pop-up Workbook Connection window, we click on the right side of the property button, in the next window, we choose to customize.

4. After that, we click on the "Edit Query" at the bottom of the window, and then we can open the external website and make the data import.

When we need to use the data, the problem is that the data can not be imported is really a headache ah, small series of methods described above can effectively help solve the problem, meet the same problems of the small partners hurriedly try it!