How to Synchronize Spreadsheets in Excel

Written by ken burnside Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Synchronize Spreadsheets in Excel
Synchronising (calculation image by lefty from Fotolia.com)

Excel has two ways to synchronise data, both between separate spreadsheets (by linking files) and between worksheets in the same sheet. This is useful for building summary spreadsheets and for ensuring that changes in one worksheet are reflected (and replicated) in others.

Skill level:
Easy

Other People Are Reading

Things you need

  • Excel 1995 or later

Show MoreHide

Instructions

  1. 1

    Open the workbook with the data you expect to be shared in Excel. This is the source workbook.

  2. 2

    Open the workbook you want the data to be replicated in. This is the destination workbook.

  3. 3

    Select the cell in the source workbook you want the data to come from, and enter "Ctrl+C" to copy it.

  4. 4

    Switch to the target workbook, and select the cell you want the data to appear in.

  5. 5

    Enter "Ctrl+V" to paste the reference in. If you examine the formula, you'll see that prior to the row and column entry, there will be a reference to the drive location (or network location) and the file name of the source workbook. An example would look like this: [C:\Book1.xlsx]Sheet1!A1. This means that Excel will pull the value from the linked file.

  1. 1

    Open your workbook in Excel.

  2. 2

    Hold down the "Ctrl" key while clicking on multiple worksheet tabs. Be sure to leave one tab unselected when you do this. This will ensure that any edits you make on one tab will be replicated across all selected tabs, with data entered in the corresponding cells.

  3. 3

    Click the tab that's not part of the group to undo the tab group selection. This will get Excel to revert to "normal mode," where changes in one tab only affect that tab.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.