How to Link Workbooks in Excel | Connect Workbooks with Automatic Update

In this Microsoft Excel video tutorial, I demonstrate how to create a link or connection between two Excel workbooks. The link or connection will automatically update.
🕰️Timestamps
00:00 Introduction
00:28 Make a connection by referring to a range in another workbook
02:52 Make a connection by referring to a Table in another workbook
04:27 Use 'Existing Connections'
#exceltips #exceltutorial #exceltricks

[@alexrosen8762]

Superuseful tutorial. Thanks 🙏

[@selimshixmambetov9706]

Good afternoon, thanks for the cool lesson, I had a question, I also made 2 sheets, but in Excel Online for some reason my changes are not automatically displayed on 2 sheets, and after 10 minutes? What should I do? how do I make the changes appear immediately?? Thanks for the help"

[@gonzinigonz]

Was talking about doing this again today. When I've tried this in the past linking to a file on Teams it was very flaky though did kinda work. But maybe your not supposed to use it like that? I need to find it and have a look again.

[@mavsbellen9975]

On my situation, I have the mother file and my team has their own files linked to mine. But everytime I go refresh, it opens a copy of their files.

[@loansbydb]

So is there a way for us to put new data into the connected book and have it update the original source?

[@philipchek]

Thanks, I've also watch this one (watch?v=zqFYP8yjkUY) on about the same subject, but it doesn't solve my problem. I see in your both (very good) videos, the original workbook is always opened. But it happens that problems may sometime appear with Excel 365 when the source workbook is closed. I have formulas that get their values from others worsbooks, this worked fine from many years. With office 365, the formulas won't update automatically anymore, but Excel asks me if I want to update : that's fine enough for my needs... but too bad the formulas don't update anyway and I get an #REF error in the linked cells. Of course I've checked the path in my formulas, it's a full path (automatically written by Excel), and anyway the involved files are all in the same directory. When I open the workbook where the datas are, then the formulas are updated. Searching on the net, it seems I'm not the only one with this problem. Any idea to help me ?