How Can I Get Two Excel Spreadsheets to Update Each Other?

By Carter McBride

Microsoft Excel is a spreadsheet program. You can use it to enter your data into the spreadsheet in order to perform various functions. If you have two spreadsheets that are interrelated, you can link cells to both. When you do this, if you update the cell in one spreadsheet, it will automatically update in the other, even though they are different files. Use one spreadsheet for your primary updates.

Step 1

Open both Excel spreadsheets.

Step 2

Go to the spreadsheet that you want to update manually.

Step 3

Right-click on the cell you want to automatically update in the other spreadsheet.

Step 4

Select "Copy."

Step 5

Go to the spreadsheet that you want automatically updated.

Step 6

Right-click on the cell you want to automatically update.

Step 7

Select "Paste Special."

Step 8

Select "Paste Link." Now whenever you change the cell in the spreadsheet you update manually, it will be updated in both spreadsheets.