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
Пікірлер: 9
Thanks a lot!!!
Superuseful tutorial. Thanks 🙏
Thanks for the video. I save both files in the same folder and copy the folder when I need to copy it to another computer or OneDrive. When using external connections what is the best way to make the path relative so I can copy the folder. Thanks a lot.
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.
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"
So is there a way for us to put new data into the connected book and have it update the original source?
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.
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 ?