Workbook links various behaviours - New 2023

Linking Excel files has always caused issues, with this new feature though it is much better managed and easier to control. I go through a multitude of scenarios, from formulas to PivotTables, charts to data validation and more to see what is working and what is not.

PivotTables at the time of this video still has a hidden link, but data validation, charts, and conditional formatting no longer do.
Follow Solve & Excel's monthly newsletter for monthly Excel updates: https://solveandexcel.ca/excel_news/
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/socials.html
00:00 Introduction
01:13 Linking cells
01:41 Pasting data validation
03:07 Conditional format from another cell
04:07 Named range
04:36 Charts
05:04 Breaking links
05:24 Formulas
06:04 PivotTables
07:20 Summary

Видео Workbook links various behaviours - New 2023 канала David Benaim