Excel Online Link to Other Workbooks (Files, Spreadsheets) - OneDrive

Learn how to link to data from other workbooks (files, spreadsheets) from OneDrive in Excel Online.

#excel #online #link

[daklaker]

How can i enable content automatically to update the link? no need click “enable content” at the security notification because i want sharing data automation from file 1 to another file online everytime.

[ashvinchavda]

Best learning video for me.
Thats is very simple but .... No one can't sow in video.
Thank you so much

[forextradingmadeeasy]

Is there any solution to get reference from different site address worksheet?

[gam]

hello, thank you for this tutorial. so helpful since not much is written or demonstrated about excel online.
how about if i need to link the workbook as a hyperlink?
Example: in work book 1 i would click on the hyperlink inside the A1 and it would launch the work book 2.

[youngistanrocks]

BRAVO...!! ☺️ Absolutely terrific... Thank you so much. This is what I want since long.

[kharismanurmuhammad]

how can i vlookup to another workbooks ?

[momocoong]

เฌอปรางอธิบายดีครับ แต่ผมละสายตาจากเค้าไม่ได้เอง 🥹

[MuhammadIbrahim-nqmq]

Well explained!! I got it working here just as you have described. However, I have a concern. The security warning and having to click "enable content" is a trouble as I need to click on it every time I close and open the workbook. Is there any workaround to make that a permanent selection? In other words, once I click enable content, it must not ask me all the time I refresh or reopen the workbook. Awaiting your response . Thank you!

[SaadTrolley]

Link not working when impaste the link its not accepting as look up value

[vcp]

Thank you so much for creating this video and explaining this perfectly! My job has migrated to Microsoft 365 when we were originally using G Suite, and this resolved my dilemma since I am used to the import range function offered by Google sheets.

[arindamoitra]

Interesting video on Microsoft Excel online use case. However, this is still far inferior to Google Sheet's IMPORTRANGE function, particularly when paired with the QUERY function.
Also, please create some videos on new Office Scripts.

[Sulsinner]

I linked my two files and its not updating. is it like every 24 hours or so? im confused.

[nikalevidze]

Is there a way to create the link using Concatenate? Can that kind of a link be referenced by excel desktop or excel online?

[janeleong]

How do I go to reference cell directly for excel online? Because if using excel, I can just cltr +[, but it does work in excel online. Anyone have the solutions?

[moesadr]

What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?

[prempatel]

Hello sir, I am using list files, folders and multiple thigs you taught... but at one thing i need your help. I have a column with google drive shred files links and i wan to download or add this files into columns beside it. Is there any for doing this

[junioraraujo]

It doesn't work for me. This option to collage with the link is not available. Or that you do not know your Excel, for this option to filter with the links, are they visible?

[ronelarinal]

how about xlsx file in google drive? can u make it combine? thank in advance.

[xyzakho]

Hey, new subscriber here, and thanks for creating this video! I happened to need this in work. Would you be so kind enough to share your expertise. What if I want the columns (say you have a table) to be dynamic? I can just omit the row numbers right in the code and just leave the column letters. But when you try that in excel online (OneDrive), it treats blank cells with a value of zero. Do you know how we can keep those blank cells just blank? I was thinking of using the IF function, but can't quite get the right formula.

[faruqtraders]

Hello i am zayan from Bangladesh🖤 i made a Google sheet for my office expenses. I want to make it more user friendly so that my employer can easily submit their data.
I have planned to add a submit button on my sheet by pressing it, it will send their expense data to the master sheet🙂 but i don't have any idea about app script. Can any body help me with that😊