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.
5 FREE EXCEL TEMPLATES
Plus Get 30% off any Purchase in the Simple Sheets Catalogue!
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
5 FREE EXCEL TEMPLATES
Plus Get 30% off any Purchase in the Simple Sheets Catalogue!
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
