Download the featured file here: https://www.bluepecantraining.com/wp...


Blue Pecan Computer Training Ltd offers onsite or online Excel training for businesses. Training can be delivered at your business premises in the southeast of England or via Teams wherever you are in the world. Visit our training page at https://www.bluepecan.co.uk

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.

Table of Contents:

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