Skip to content
Home ยป Automatically Update Data in Another Excel Worksheet or Workbook – 3 Methods

Automatically Update Data in Another Excel Worksheet or Workbook – 3 Methods

     

    So you want to automatically refresh data in another Microsoft Excel workbook or worksheet. This video explores three methods for how this can be achieved: cell referencing, table referencing and Power Query.

    Click here to download the featured file

    Video Table of Contents

    Use the time stamps below to navigate between the video’s chapters.

    00:00 – Introduction

    00:34 – Using sheet cell references to link and update across worksheets

    02:20 – Copy and paste links to link and update across worksheets

    03:18 – Link and update across workbooks using cell references

    05:26 – Using cell references to auto update new or amended records

    07:48 – Using tables to link and update data across worksheets

    11:31 – Using tables to link and update across workbooks

    12:57 – Using Power Query to link and update across worksheets

    16:10 – Using Power Query to link and update across workbooks