How to Make Connections between Two Excel Worksheets

Excel can help us analyze data of different information. But the data in different workbooks will reduce our work efficiency. So today we will introduce about how to make connections between two worksheets.

If you need to use Excel to finish your task, there will certainly be many different workbooks in your computer. And sometimes, you need to compare the data in two different workbooks. However, it will be a little inconvenient to switch between two files. Thus, you can make connections between the two workbooks.

Make Connections

Now, you can follow the steps can create the connection according to your actual workbook.

1. Open the file.
2. In the tab of “Data”, click the button of “Connections”. And then you will see a new window pop up.
3. In the new window, click the “Add”.
4. Then you will see a new window pop up. Click the option “Browse for more” in the window.
5. In the new window, choose the target workbook that you need to make connections.
6. And then click “Open”.
7. After that, you will see another window. And in this window, you need to choose the target worksheet.
8. And then click “OK”.
9. Now, you can close the “Workbook Connections” window.

Import Data in Other Workbook

Now that you have made connections between two workbooks, you can import data into your workbook.

1. Select any of a blank cell where you want to put the data in.
2. Click the button “Existing Connections” in the “Data” tab.
3. Then in the new window, choose the file that you have set connections with.
4. And then click “Open”.
5. In the “Import Data” window, choose the type that you want to view. And here we select “Table”.
6. Then click “OK”. After that, you will find that a new table appears in your worksheet.

Therefore, now you can compare the data in two different periods.

Delete Connections

In the future, you will no longer need to use the connections. Thus, you can delete the connections.

1. Click the “Start” in your computer.
2. Then click “Document”.
3. In the new window, open the file “My Data Source”.
4. Then delete your connections.

Remedy for Excel File Corruption

In the process of using Excel, you will sometimes unfortunately meet with Excel file corruption. If you don’t take any measures, you will lose all your data in the end. Thus, you should take remedy and rescue your files. In addition, a third party tool can be your helper. It can fix Excel files in a short time and make sure that your data is safe.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com