HomeApplicationOffice information

How to link data between excel files together

In the course of using Excel, you may need to use data from one file to another quickly, but the data changes are still updated by linking links between data files. how to practice? Let's find out through the article below.

To get data from one excel file to another, we need to perform the following 7 steps:

- Step 1 : Open 2 excel file

How to link data between excel files together Picture 1

How to link data between excel files together Picture 2

- Step 2 : Open the location to save the excel file to retrieve data (for example, this is excel file 1). Right-click on the file and select properties

How to link data between excel files together Picture 3

- Step 3 : copy the Location link, click OK

How to link data between excel files together Picture 4

- Step 4 : Paste the path into the excel file to get data

How to link data between excel files together Picture 5

- Step 5 : add excel file containing the data as shown below

How to link data between excel files together Picture 6

- Step 6 : copy the path = 'C: UsersAdminDesktop [thang3.xslx] Sheet1 ′ !. Then go to the excel file containing the data (namely, excel file 2). Click on the data box as shown below

How to link data between excel files together Picture 7

- Step 7 : into the excel file to get data (excel file 1) and paste the path = 'C: UsersAdminDesktop [thang3.xslx] Sheet1 ′! as below picture

How to link data between excel files together Picture 8

- Press Enter to see results

4 ★ | 1 Vote

You should read it

May be interested

  • How to Automatically Report on ExcelHow to Automatically Report on Excel
    today's tipsmake will guide you how to automatically report data on microsoft excel. this article also talks about how to query and create reports from external sources (mysql, postgres, oracle, etc.) right on your spreadsheet using the excel plug-in to link your spreadsheet to the source. that data. as for data stored on excel spreadsheets, we will use macro commands to create and export reports into many different file types with just one keystroke. luckily, excel has this feature built in, so you won't need to create your own algorithm.
  • How to fix Errors were detected while saving files in Excel 2010How to fix Errors were detected while saving files in Excel 2010
    in the course of working as well as creating excel data tables, you'll get a lot of errors like errors were detected while saving files in excel, affecting saving excel files.
  • How to create suggestions for Hyperlink in ExcelHow to create suggestions for Hyperlink in Excel
    creating suggestions for hyperlink on excel or tool-tip hyperlink is a comment when you hover your mouse on the link link in excel, so that users have more information about that link.
  • How to retrieve unsaved Excel files, restore unsaved Excel filesHow to retrieve unsaved Excel files, restore unsaved Excel files
    how to retrieve unsaved excel files, restore unsaved excel files. in the process of working with excel file, there will be times when you encounter problems closing the excel file without saving the data while editing. you are not sure how to recover and recover
  • The website Get Link Fshare, 4Share has no pop-up adsThe website Get Link Fshare, 4Share has no pop-up ads
    if you regularly download data files, videos, software from fshare online, 4share, please refer to the get link fshare website, eyxx does not have pop-up ads shared by the network administrator below.
  • How to recover Word, Excel files when deleted with Data Recovery WizardHow to recover Word, Excel files when deleted with Data Recovery Wizard
    this sharing article will guide how to get word, excel files when deleted from your computer is very simple. when you lose excel or word files on your computer or external devices such as usb flash drives, portable hard drives, a simple way is to use the data recovery wizard software.
  • How to link data between spreadsheets in Google SheetsHow to link data between spreadsheets in Google Sheets
    most of us are familiar with basic operations when using spreadsheets in google sheets such as using specific rows and columns, calculating, creating pie charts, columns, data lines, etc. however, today's article will show you how to link data between spreadsheet pages in google sheets.
  • Excel data entry fasterExcel data entry faster
    you can completely enter data without re-entering the same information you entered from other sheets or files in excel. there are many ways to make importing data in excel faster and smarter without even touching the keyboard.
  • Find and delete duplicate data in ExcelFind and delete duplicate data in Excel
    find and delete duplicate data in excel. in the process of working with excel spreadsheets, there will be excel files with large amounts of data so duplication of data is very common. there are cases where duplicate data is useful, but sometimes values ​​are
  • How to Compare Data in ExcelHow to Compare Data in Excel
    this tipsmake article will show you how to compare two different data sets in excel, from two columns in the same spreadsheet to two independent excel files.

Office information