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

[@bluegreenorbs]

Hi! Thank you for the tutorial! I used this method to link multiple workbooks to create an overview document. My problem is that the search function is not working. I assume it's because the cells contain the references and not the actual data. Is there a way to be able to use the search function?

[@ralphbenoy4538]

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.

[@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.

[@nasreenbanu1105]

So after linking workbooks we should manually change format, is it?

[@CXN215]

Would i be able to use this function across 10 or so worksheets?

[@alexrosen8762]

Superuseful tutorial. Thanks 🙏

[@bassemkayali7004]

Which excel version used for this video? as the range example didn't work for me.

[@virendrahardiya2797]

How can we make same formatting after refreshing as if we insert or delete any row, any columns, I absorbed that formate is not adjustable while inserting or delete any row or column.

[@suparinya6408]

Thanks a lot!!!

[@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?

[@kevinbush4300]

There's always one, isn't there??!! 😂

[@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 ?