Mynda - You are an exemplary teacher. Thank you so much for this information. As a retired scientist who helped to get VisiCalc adopted in research projects at the University of Southern California, I understand and appreciate the information. However, it will take some study. Your pace and style of teaching makes the learning process both efficient and solid. Keep up the good work!

Thanks Mynda,. I;ve been waiting for this methodology ( embed dashboards in web pages) for years !!! Thanks so much for delivering videos which address practical real life needs. Once again your are superb !!

Dear Mynda, the surprise factor of your content is always =MAX()! This is so cool, I designed a dashbord in Excel fed by Power query and was wondering how to make it more like Power Bi rather than hiding sheets which can be easily circumvented! I have been following for a while and love the content and your delivery!!!👏🏻👏🏻👏🏻

Mynda, this is brilliant!! Just want to let you know, when I see your emails, I get so excited and immediately watch.

Informative and simple to follow through. Thank you Mynda.

Thank you. Very useful and I appreciate the summary of pros and cons at the end.

Excellent video as always, thanks Mynda!

Bingo, you nailed it, a most awaited video

As always, terrific & timely! Thanks!

Great Mynda Thanks again for a very useful video.

Great tips for security using JavaScript vs Embed code. Thanks for sharing!

WOW!!! Excel with coding! SUPER AMAZING Goddess of EXCEL!!!! Thank you ALWAYS

Hi Mynda!Excellent Tutorial And Really Helpful...Thank You :)

Hi Mynda, thanks for sharing this useful tips. share more tips & be blessed always.

Que buena info! Muchas gracias Mynda!

Another incredible Video by a mind-blowing online tutor, thank you for all your work Mynda.

Great video. Thank you very much ♥

very helpful .. thank you so much !!

Great solution! I thought I have no embed option for business one drive and this video helped me a lot!

Thank you for the video! Is there a way to print the users results from the ?

very helpful!thank you. I have only a personal one drive account and the javascript somehow didn't work for me so I just add a text block to the excel page where the download icon is

Excellent. thank you.

Great video. Literally creating a wellness dashboard as we speak and need this. My biggest question is how do you write the code to include multiple Named ranges as I will be using hyperlinks to jump between sheets

Thanks for the video! I always appreciate your content, has been a constant source of help for me. Question about this subject - no matter what I do I cannot get rid of the scroll bars, I'm using scrolling = "no" but that's not working and I've tried dozens of pixel sizes, any ideas?

Thank you for the clear tutorial! I love your voice!

wow... best ecxel content 👍

This is great! Thank you very much for all your great videos. Is there a way to embed this into a Sharepoint site in an analogous manner? I’m not familiar embedding, so I don’t know if this is a silly question or a simple one.

Dear Mynda, I am so impressed by your work and I am very grateful for your kindess. I want to create dashboards to offer as a subscription service. I am wondering if I should make them in Power BI or stay with Excel. I don't know Power BI it yet! And I don't know if users would have to have a Power BI license to view an embedded website? Thanks for leading the way!

Thank you for taking the time to make this video. Following the method in the video means that the is visible to people within the organisation however, I can't see how to make it visible for people outside of the organisation. Any help or suggestions would be greatly appreciated.

Wow great 👍👍👍

If you're embedding to a SharePoint page, remove the https from the src URL in the embed code to get rid of the grey box with the file type icon. That way all your charts or tables will display without the user having to hover over them. Also, create your spreadsheet in a sharepoint file folder, rather than on your desktop/onedrive, or you'll get external data query popups. Something must configure in the file if you create/save it in your onedrive before uploading to sharepoint, and it doesn't alter whatever that config is, which is why I always create spreadsheets for sharepoint on sharepoint first, then open in app to edit.

Dear Mynda, thank you for another great video. Now, I need one solution on the same concept. Can we add print button on embed view?

Thanks for the great tutorial, Mynda. Do you know where we can find a list of parameters that can be added to the code? I google it but couldn't find anything helpful. Many thanks in advance.

As always an amazing video and great at explaining this... Have a question for you, would it be possible to set this up on a website based on a LAN Network?

10MB! that is very small... too bad, it seemed like and excellent way to share Dashboards without sending the file. Thank you. If anyone hears that bigger files can be uploaded, please let me know. thank you, great content, great videos!

HI Mynda, great video! is there any video that you instruct how to paste JavaScript from OneDrive in to Wordpress? Becase it is not the same "Embed code" tap, when I did with JavaScript tap, nothing happened! Thank you!

Hi Mynda: thank you very much: very technical video this time, but a great reference once you need it. How about the easier way: select File, Info, Browser View options and then select only your dasboard sheet. Do you mean that users can download the rest of the file? I thought this was save as well?

Oooh this is so great! Can you embed live data? Such as importing a stock price and use it to calculate a number? Than show that number live in the embed?

Thanks for nice way to share data. I wonder is it possible to block users to open excell file (that last button on bottom right of )

Thanks!

Thanks Mynda, your excel tutorials are really outstanding and helpful. Using the java embed code to protect and avoid downloading excel files is really cool. Only the Interactivity options seem to be less than using with the same restrictions. Can it be that this is an issue with wordpress? Any hint would be great.

hi I cannot get interactivity working with the java version; presumably inserting "allowTypingAndFormulaEntry: true," but there is no effect. Anyone any advice pls? thanks...I dont think it is a wordpress issue because the embed interaction works ok

Thanks! 👍❤️

Hi Mynda, thanks again for this sharing. By the way, if I choose from my onedrive personal & wish to customize the width & height, can I follow your method from the one drive for business from JS? my chart range is very wide, by default JS limits to only width: 402px; height: 346px". as a result, I could see the bottom scrolling bar. i want it make it fit to screen. thanks

Thank you Mynda, great video. Quick question. I have a sharepoint page for the team. I would like the excel file to appear withing the sharepoint page but I need the team to be able to make changes and the changes be saved. Is this possible? The original excel file is stored on onedrive business.

Very good! Just a question: I can use power query and or power pivot for that kind of dashboard?

This is such a helpful video I landed upon. Thank you.. Is there a way we can keep the pixels dynamic which adjust based on the device its virwed on..

Mynda, thanks for this video and all the insightful excel knowledge you shared on your channel. I recently came to an issue when embedding public view excel dashboard to my website. It always came to a "sign in" page from MS 365 regardless what level of access. The public view url to the excel can be accessed without any issue, just the embedded site show the "sign in". Not sure if you came across with it?

Mynda, great work. Is it possible to add an embed excel that allows the user to interact and save their changes to the excel?

Hello Mynda- This is a great video and I've referenced it thoroughly. Is there any chance Microsoft has changed things quite a bit? When sharing a document, I'm not seeing the same menus or options (ex: There is no Javascript option). I've tried this on both business and personal accounts and can't get it to work right. Also, with the parts I have gotten to work, if I edit the embedded web version, it's not updating the shared file. Have you noticed the same? Thanks! Great work.

Thank you so much. Any ideas of how to hide the black bar at the bottom. Thanks

Another great video! I tired doing the Java thing you showed in this videos and it worked great. But the only problem is that I want people to paste large amount data into a table I created and embedded. But it seems like you can only paste data into one cell at a time. When you copy data from an excel sheet and paste it onto another excel sheet, it separates the data into an appropriate number of columns and rows. But for some reason it does not do that on an embedded excel sheet. Is there a fix for this? Thanks again for another great video

OneDrive no longer gives the option of JavaScript :( Could you please do an updated video on this? Would love to know any other way we could embed securely on a website. Thanks again, love your work.

Hi Mynda thanks for the tutorial!! How can you refresh the Dashboard from the page itself with out opening the document?

Hello! I would like to place an from one drive but with a pdf file... How can I complement the url of the so that it can be seen on a website for the public?... place the options that you placed in the video, but they are only for excel files... thanks for your great help!

very informative video...is there a way for the user to print the results in a pdf format?

Thank you for the vid ! I'm using SharePoint and when I open the webpage I can only see a tiny "window" of my Excel sheet. What do I have to do to have it as large as yours ? (almost full scree)

Great explanation! Would love to know if there is any way we can allow the users to save their changes to embedded excel but don't allow them to download the excel?!

Hello I hope you are well, thank you for the video. Can you help me by confirming how a complete excel file could be placed? I have an excel that uses several pages, tables and macros to make quotes. I would like my clients to be able to quote online from my website

Thanks

This is awesome. Please help me how can I disable the download link in the footer. The link is so annoying because it opens up the whole file and allows to save a copy of the file as well. Thanks.

Hello, is it possible to share an excel workbook with others and allow editing, but block downloading? We want other users to be able to edit a file and the changes to be saved to the document but we don't want anyone to be able to duplicate or download the file as it has sensitive data within it

Hi , can we do same actions programmatically ? May be using some APIs ?

Hi Mynda, Ive got a question regarding the bottom viewerbar that is shown when the spreadsheet is embedded. I used Onedrive/sharepoint for business yet the viewer bar still displays the URL and the embed code. Could you give some suggestions to eliminate at least those two options for security? Thank you.

Wondering how to use embed code to make online,where to paste embed code

Dear Mynda what is the wd command I can use to reduce the view inside the . Instead of the default 100%, it can be changed down to 80% or 60% or whatever it needed.

I've said this before and I'll say it again, absolutely love your videos! My thing I am stuck on is that my work sheet has stock data on A2. If I type a stock ticker like GOOG or AAPL on that cell, it will tell me the name of the company and other company info. When I embed this sheet, it seems to stop pulling these data from online when I change the company ticker. For example, on the website if I type in AAPL on A2 it won't return with "APPLE". Do you know a way to fix this?

Hi Mynda, thank you so much for this amazing guide. As a first timer, I got lost at the point where I am supposed to run the embed code. Permit me to ask this; do I need to create a personal website before I can be able to run the codes, if no? how do I run the embed codes as I am stuck at that point. Thank you for all you do..

Hello Mynda , can you explain how to embed the dashboard for offline website without internet and hence not using SharePoint

Dear Mynda, thank you for the weekly tips and videos. Very helpful. With this video, I'm struggling, as my excel doesn't show on all devices. Sometimes (also with the people I tried to share the webpage with) receive the message from Microsoft 365: 'sign in to view this file' with a button. Do you know how to avoid this? Thank a lot

HI i tried uploading dashboard on one drive but my dashboard in one drive is not the same ( having some issues) one which I uploaded. Some data location changed, few slicers not working as I want them to work. Please help

Ho Mynda. Please let me know if JavaScript is still supported for embedding? As I see only

Dear Mynda my teacher, I am also a subscriber of your channel because I learn a lot from your videos. I embed a file that has a PowerPivot to manage the data, but when I embed the item in my site I receive a message about an external link issue. Could you please suggest to me what to do?

Hello, Myanda! I have a question! If I want to embed a private excel file on a private web site, Can I do it? This excel will have some sensitive information of my company and I can not share with the public. What I can do? Thks

Boy I'd love to get this to work but so far no such luck. It seems like Microsoft has removed the “embed” link from the business one drive environment and the personal one drive environment. I can see lots of references on the web and at youtube for how this used to be done and it looks great. For now it seems like you're starting with a file link and then creating a block of code around it and keeping your fingers crossed. I keep getting errors indicating that there's a permissions issue with displaying the file but the Microsoft environment certainly seems to indicate that the file is open to anyone and everyone. I have a support call into Microsoft. Do you have any suggestions?

How do you imbedded the Javascript and where do you put it in the html

Hi Mynda, I'm getting an error 'SharePoint refused to connect' when I'm trying to open the final html file. Any idea on how to resolve it? Thanks a lot

Which version of Microsoft subscription are you using madam? I subscribed to M365 onedrive for business but i'm not getting same option.

Is it possible to embed Power BI Desktop dashboards in web pages for free as well? Or is that conditional to having a paid subscription?

How to protect from copy paste? I made protection sheet it work only Excel Desktop or Excel online but when it's embed, people can select row and copy paste.

I'm finding that when I upload to onedrive personal, the formatting of the file in Excel online is messed up. It doesn't have my font, so it replaces it, and it doesn't allow the form controls.

I have 100 sheets in one work book, in my first sheet of same workbook, I have the list of names of all 100 sheets, now I want to hyperlink these names to the corresponding sheets, so that if I click the names I want excel to go to that particular sheet how to make it, any idea, thanks.

Hi, I really like your tutorial, but unfortunately when I try to embed my worksheet, it shows-up within the excel app not just the worksheet. How do I correct it?

Hi there.... I need some help regarding embedding my excel sheet to my website as my excel contains macros and vba

Hi Mynda, I wonder if Microsoft have changed something again? I am trying this in a SharePoint Online intranet and, no matter what I try, it displays the whole spreadsheet, complete with tabs and ribbon. I have a Chart named TimelineChart and have specified that name with &Item=TimelineChart - In fact I even tried copying your own code, changing only the URL (removing the "Https:" as suggested by one of the other posters) and the Item name, and pasting it into the "Embed" Web part, but it still displays everything. Very frustrating as this approach would have solved several problems for me.

did you copy the notepad to a website ? how did you embed it

Does it allow macros and user forms to run?

Hi Mynda, I try to use this way to display the excel in my HTML file, it work at local folder but once I uploaded to one drive or share point it cannot display is that any possible solution ?

I do not see the embed option when I select the file in my OneDrive

I followed the same process but when pasted the link on Google browser, it's showing Google results instead on Excel.

Does the data behind the dashboard automatically refresh when they open the webpage, or does something need to be done to make that happen?

Sadly does not work for me with Onedrive for Business. Same file works on OneDrive Personal non-Java. Does not work when Javascript. Any ideas? Thanks.

4:44 How do I load the code in Explorer?

Is there a possibility to remove the black bar in the embed

When I try to get to the settings for the excel sheet in one drive for business, I don't see the link settings? Am I doing something wrong?

Where is excel embed code added in Sharepoint page?

Why don’t I have block download