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.
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"
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.
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.
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 ?
![[TH] 2024 PMSL SEA W3D1 | Fall | สัปดาห์ตัดสิน ทีมไปไฟนอล](http://i.ytimg.com/vi/ZBU3GyzqErI/mqdefault.jpg)
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.
Superuseful tutorial. Thanks 🙏
Thanks a lot!!!
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"
Would i be able to use this function across 10 or so worksheets?
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.
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.
So after linking workbooks we should manually change format, is it?
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.
So is there a way for us to put new data into the connected book and have it update the original source?
There's always one, isn't there??!! 😂
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 ?