Set merge Excel same table and refresh tutorial immediately

For example, each month to do a multiple table combined analysis, you can let the data table to the specified directory, the merged table will take the initiative to obtain new data, in the combined table of the analysis and the chart will be active update, and then do not need to do a repeat of the work every month.

Operation Steps

1, open Excel2007, click the menu bar--data--Get external data--from other sources--from Microsoft Query.

2, pop-up Select Data Source dialog box, in the Database tab, select Excel files*, click OK.

3, select the workbook, here I choose the D disk in the March workbook, OK.

4, the Query Wizard interface, first click the option button, from the Pop-up table options interface Check system table, OK.

5, see an available table, click the right arrow, import, always click Next until completed.

6, the following start to import the official data, select the data in the workbook display mode, as well as placement location.

7, the first table insert complete, the same method continues to insert the 2nd table, the 3rd table and so on.

8, below, we test the data support does not support immediate updating, in the March data table, a new insert row of data.

9, back to the beginning of the table, click the menu bar-design-refresh, see 171 lines immediately show the data we inserted in the previous step, the results show that support for immediate updating.