For everyone who is using oneDirve Business.... you won't find the embed option. To still use this method, please open the file, click file (in the menu bar) then save as -> share and there you will find the embed option. Still - thank you very much for your video it really helped me a lot. First I only was disappointed why I can not find the embed option.
@@websquadron as far as I know that's the difference. At least what I have found in a microsoft forum stated from microsoft itself. I found your video, got really excited and was then disappointed because I wasn't able to find the embed option. Then I found the difference plus the workaround so I thought I should share it in case others have the same problem.
Thank you so much, I've been looking for this! One question, I'm using Opera browser and Elementor for my web, how do I block the copy option when left clicking on my embedded excel? ppl can't edit my excel but they can still select and copy.
I'm sorry if this answer is here somewhere but I want my students to be able to access the excel sheet on our school website and be able to enter data and have it show up on the home version of the excel spreadsheet on SharePoint. It seems to be that only changes on the SharePoint file show on the website version but not vice versa. Is there a way for the changes someone makes on the website version can show on the SharePoint version making it two way?
Hello Sir, I have use the same way you told in this video and the calculator is also start working smoothly but after some time instead of excel calculator it shows me a white blank webpage and when i check my embed url i found this. As you may notice, the source was supposed to have my file's location or https, however the parameter now was generated as src="?
I can confirm this, the Source is missing in the Onedrive Personal Embed Code, instead it just shows src=?. You have to copy the source path from the previous page into the embed code to get it to work. Typical microsoft slop :(
Thanks! Great idea! I'll try. What is the difference if I paste there as an image (not good for seo persp.), or in a simple html code ( good with seo perspective) into wp page. Why Im askin is i would like to give the opportunity to the crawler robots to check the text in the sheet as sometime i add info into the sheet which is important from SEO perspective too. What is your experience with this solution? Thanks, Rob
im having a client right now where its a restaurant that has their entire wine list in an excel file and they want to be able to just have that displayed on their website , cuz its updated often
Good day sir. I wanted to know if you can assist. When I tab the 3 dots or even right click, I don't have the option 'embed'. Sorry if this question if vague.
Me too now - but last week it was there. Possibly the latest Microsoft update. So annoying. You can still embed from within the spreadsheet on MyDrive. Click File, Share, Publish to Web. It's not as good but still works.
I also do not have an embed option. I am using my college administrated OneDrive. If you are also using OneDrive through a school, that might be why we can not embed things. Schools might disable this function?
@@LiveAndLove91 Yes, it is possible for certain versions or configurations of OneDrive to not display the "Embed" option. The availability of the "Embed" option depends on the specific features and settings enabled for OneDrive by the administrator or the account holder. The "Embed" option allows users to generate an embed code that can be used to embed files or documents hosted on OneDrive into websites, blogs, or other platforms. However, the availability of this option can be restricted or disabled for security or privacy reasons. If you are unable to find the "Embed" option in your OneDrive interface, it is recommended to check the settings and permissions associated with your OneDrive account. Additionally, if you are using OneDrive within an organisation or through a work or school account, it is possible that the administrator has disabled the "Embed" option for security or policy reasons. If you require the ability to embed OneDrive files and the option is not available, you may need to reach out to your administrator or account provider for further assistance in enabling the feature or to understand any limitations that may be in place.
Thumbs up! This is just what I was hoping to find - BUT I am unable to have any other load the page without signing in to their Microsoft account, and when they do - it appears I have to give them access in my sharepoint library? What step am I missing to make it available for everyone?
I love the video. Problem is when I go to embed the code t comes up as expected with the but there is no "customise how this embedded workbook will appear" underneath-Totally stumped. Can you help please? I have been trying everywhere...Thanks
Just what I needed! Bonus question, any ideas on how to create a log of what values people change? I have a spreadsheet with a few inputs and it would help me gather what most people input. Maybe I can track changes? Any thoughts?
It was great I still have one problem, is it possible to guide how to disable the Excel toolbar that is created in WordPress so that users do not enter Excel 365, thank you
Would it be possible to have a search bar so that the user could search the data? I want exact match data only to come up and I can’t do this with the current essential adding data table widget that I’m using
This is timely info and am using this to great effect. I wonder, however, how can we use this on pop-up sliders? For example, I have a pop-up reveal that slides out to about 60% of the screen. Can we use this to achieve a desired effect?
Thanks for the video. This is a real game changer for me. I do, however, have one issue with it. When the spreadsheet is rendered on the Wordpress page the row heights seem to be totally random, ranging from 1 row to four or five. Any suggestions?
If you have a spreadsheet linked to a table on another site that automatically refreshes daily will it also refresh on your wordpress site if embeded? Anyway to make the process automatic too. Thanks
Help! This is really clear, but when I follow your instructions and I go to the Excel file in my OneDrive file, there are no 'three little dots', and nowhere can I find an 'embed' option. What am I doing wrong, please? I'm in Windows 11 and the latest Excel.
i have a selector/calculator created in excel however i dont want user on website to change all text only the 'selector' sections - is there a way to switch certain columns off and only have the calculating sections on?
@@websquadron Thanks for response. i have another question. My client created quite a complicated calculator, it imports perfectly, however on the wordpress page it gives us a bar at the bottom that gives the visitor option to log in to microsoft office (bottom left) or view full workbook (bottom right). Client does not want this, they want the info to stay on the wesite only and NOT open in onedrive (all inputs of the calculator should do calculation only on website page - not open in antoher application) Is that possible or do you know of a plugin (other than tablepress) that i could possibly try. Tablepress cuts the spreadsheet in half and doesnt give option to scroll left - even though this option is ticked.
I have an Excel spreadsheet that retrieves stock market prices. So, the values on the spreadsheet are constantly changing during the hours that the stock markets are open. Is there a way to embed this sheet into a web page and have these constant updates reflected on the web page ? ( The only way that I can think of is to keep the file open in Excel somewhere that is constantly saving to Onedrive which is not very practical. )
@@websquadron yes, I am. In the past, I have the option to customise how I want my embedded link to look like. But now it is not appearing again. The excel sheet is a user interactive calculator, that is why I need to customise it.
Hi! When I try to paste the code into wordpress, it remains two lines and doesn't expand the way that your code does. As a result the spreadsheet won't come up and it says 'refused to connect'. How can we fix this?
I did this successfully a week ago, and now the embed option doesn't appear anywhere on My Drive. I can embed it using the File- Share- Publish to Web , but there are no interaction/publishing options. Off to learn how to set the size but it was so easy before! Google Sheets is not an option as I need the sheet to be searchable, that's where this video solved my issue.
For everyone who is using oneDirve Business.... you won't find the embed option. To still use this method, please open the file, click file (in the menu bar) then save as -> share and there you will find the embed option.
Still - thank you very much for your video it really helped me a lot. First I only was disappointed why I can not find the embed option.
Thanks
Not sure why I can still see it.
So I log into One Drive.
Go to the file. Click the 3 dots.
And there is the embed.
@@websquadron are you using oneDrive Business? or personal oneDrive?
@@timr.9924 One Drive Personal
@@websquadron as far as I know that's the difference. At least what I have found in a microsoft forum stated from microsoft itself. I found your video, got really excited and was then disappointed because I wasn't able to find the embed option. Then I found the difference plus the workaround so I thought I should share it in case others have the same problem.
@@timr.9924 I totally like what you did there so hopefully others will use it as. workaround when needed :)
Finally, just what I have been looking for. Thank you very much!
This was very helpfull, thanks! Exactly what is was looking for, you explain things clear.
Great Tutorial. Thank for taking the time to share your experience and knowledge, it helps out a lot....
Very great and helpful solution , Thank you so much Imran
Hi! Thanks for the video! Was wondering if we can remove the bottom black bar, that has the icons at the bottom right, "View full size workbook"
No :( I wish that was gone too
Thank you so much, I've been looking for this! One question, I'm using Opera browser and Elementor for my web, how do I block the copy option when left clicking on my embedded excel? ppl can't edit my excel but they can still select and copy.
I'm sorry if this answer is here somewhere but I want my students to be able to access the excel sheet on our school website and be able to enter data and have it show up on the home version of the excel spreadsheet on SharePoint. It seems to be that only changes on the SharePoint file show on the website version but not vice versa. Is there a way for the changes someone makes on the website version can show on the SharePoint version making it two way?
Hello Sir,
I have use the same way you told in this video and the calculator is also start working smoothly but after some time instead of excel calculator it shows me a white blank webpage and when i check my embed url i found this.
As you may notice, the source was supposed to have my file's location or https, however the parameter now was generated as src="?
I can confirm this, the Source is missing in the Onedrive Personal Embed Code, instead it just shows src=?.
You have to copy the source path from the previous page into the embed code to get it to work.
Typical microsoft slop :(
Thanks!
Great idea! I'll try. What is the difference if I paste there as an image (not good for seo persp.), or in a simple html code ( good with seo perspective) into wp page. Why Im askin is i would like to give the opportunity to the crawler robots to check the text in the sheet as sometime i add info into the sheet which is important from SEO perspective too. What is your experience with this solution? Thanks, Rob
Not good at crawling for the seo when you embed like that
I FREAKING love you for this!
im having a client right now where its a restaurant that has their entire wine list in an excel file and they want to be able to just have that displayed on their website , cuz its updated often
Good day sir. I wanted to know if you can assist. When I tab the 3 dots or even right click, I don't have the option 'embed'. Sorry if this question if vague.
Difficult to answer that one.
Me too now - but last week it was there. Possibly the latest Microsoft update. So annoying. You can still embed from within the spreadsheet on MyDrive. Click File, Share, Publish to Web. It's not as good but still works.
I also do not have an embed option. I am using my college administrated OneDrive. If you are also using OneDrive through a school, that might be why we can not embed things. Schools might disable this function?
@@LiveAndLove91 Yes, it is possible for certain versions or configurations of OneDrive to not display the "Embed" option. The availability of the "Embed" option depends on the specific features and settings enabled for OneDrive by the administrator or the account holder.
The "Embed" option allows users to generate an embed code that can be used to embed files or documents hosted on OneDrive into websites, blogs, or other platforms. However, the availability of this option can be restricted or disabled for security or privacy reasons.
If you are unable to find the "Embed" option in your OneDrive interface, it is recommended to check the settings and permissions associated with your OneDrive account. Additionally, if you are using OneDrive within an organisation or through a work or school account, it is possible that the administrator has disabled the "Embed" option for security or policy reasons.
If you require the ability to embed OneDrive files and the option is not available, you may need to reach out to your administrator or account provider for further assistance in enabling the feature or to understand any limitations that may be in place.
Thumbs up! This is just what I was hoping to find - BUT I am unable to have any other load the page without signing in to their Microsoft account, and when they do - it appears I have to give them access in my sharepoint library? What step am I missing to make it available for everyone?
They shouldn’t have to log in.
You need to save it in your one drive and not share point library and also check that you have allowed public access
@@websquadron Thanks for the quick reply. I'll try that :)
I love the video. Problem is when I go to embed the code t comes up as expected with the but there is no "customise how this embedded workbook will appear" underneath-Totally stumped. Can you help please? I have been trying everywhere...Thanks
Is the option to change the width and height missing?
been looking for answers for this too. I don't have the option to customise how the embedded workbook will look to others button
Just what I needed!
Bonus question, any ideas on how to create a log of what values people change? I have a spreadsheet with a few inputs and it would help me gather what most people input. Maybe I can track changes? Any thoughts?
Not sure about that plus you’d have to get their permission for logging
It was great
I still have one problem, is it possible to guide how to disable the Excel toolbar that is created in WordPress so that users do not enter Excel 365, thank you
Let me check
Thank you for your kindness@@websquadron
Would it be possible to have a search bar so that the user could search the data? I want exact match data only to come up and I can’t do this with the current essential adding data table widget that I’m using
You’d need to add some macro search facility onto the excel sheet
how did you costimize the menu?
This is timely info and am using this to great effect.
I wonder, however, how can we use this on pop-up sliders?
For example, I have a pop-up reveal that slides out to about 60% of the screen. Can we use this to achieve a desired effect?
Technically if you drop the html in then yes
@@websquadron Drop the HTML?
Thanks for the video. This is a real game changer for me. I do, however, have one issue with it. When the spreadsheet is rendered on the Wordpress page the row heights seem to be totally random, ranging from 1 row to four or five. Any suggestions?
Not sure about how to fix that
If you have a spreadsheet linked to a table on another site that automatically refreshes daily will it also refresh on your wordpress site if embeded? Anyway to make the process automatic too. Thanks
Yes it does :)
Help! This is really clear, but when I follow your instructions and I go to the Excel file in my OneDrive file, there are no 'three little dots', and nowhere can I find an 'embed' option. What am I doing wrong, please? I'm in Windows 11 and the latest Excel.
You may need the Business Plan. Which plan do you have?
i have a selector/calculator created in excel however i dont want user on website to change all text only the 'selector' sections - is there a way to switch certain columns off and only have the calculating sections on?
They can never overwrite the embedded Excel. You Could protect cells with passwords.
@@websquadron Thanks for response. i have another question. My client created quite a complicated calculator, it imports perfectly, however on the wordpress page it gives us a bar at the bottom that gives the visitor option to log in to microsoft office (bottom left) or view full workbook (bottom right). Client does not want this, they want the info to stay on the wesite only and NOT open in onedrive (all inputs of the calculator should do calculation only on website page - not open in antoher application) Is that possible or do you know of a plugin (other than tablepress) that i could possibly try. Tablepress cuts the spreadsheet in half and doesnt give option to scroll left - even though this option is ticked.
I have an Excel spreadsheet that retrieves stock market prices. So, the values on the spreadsheet are constantly changing during the hours that the stock markets are open. Is there a way to embed this sheet into a web page and have these constant updates reflected on the web page ? ( The only way that I can think of is to keep the file open in Excel somewhere that is constantly saving to Onedrive which is not very practical. )
Yup, not great leaving it open manually. I'll have to think about that.
How can you make it wider on the page? Seems to have a limitation of 700px width.
It's defined inside the embed that I've added.
Is the table will be responsive in mobile?
Best used on Desktop unless built via a widget and code.
I can't find the customize embed link on my excel when sharing to my website. Any way around it?
Are you accessing via your one drive folder?
@@websquadron yes, I am.
In the past, I have the option to customise how I want my embedded link to look like. But now it is not appearing again.
The excel sheet is a user interactive calculator, that is why I need to customise it.
Hi! When I try to paste the code into wordpress, it remains two lines and doesn't expand the way that your code does. As a result the spreadsheet won't come up and it says 'refused to connect'. How can we fix this?
Not sure without working on the site.
I do not have an embed link .. I have looked every damn place and it is not there .. what is the issue
Do you have OneDrive Business?
I have ticked "Let people type into cell". However, people still can't type into the embedded excel. How to tackle it?
Hmmmm I’ll have to check
Ellipsis menu not available from my version of Microsoft 365 (Personal). Utterly maddening.
You may now need the business account.
I did this successfully a week ago, and now the embed option doesn't appear anywhere on My Drive. I can embed it using the File- Share- Publish to Web , but there are no interaction/publishing options. Off to learn how to set the size but it was so easy before! Google Sheets is not an option as I need the sheet to be searchable, that's where this video solved my issue.
I've not had this issue. Is everything up to date? You may need to reach out to Microsoft Support.
embed is not working rn any solutions?
Have you got OneDrive Business?
@@websquadron no
it is asking user authentication to show on web by one drive in WordPress. how to avoid user authentication ?
It shouldn’t ask for use authentication
customize how this will appear option is not there
Are you sure as I used this again last week?
@@websquadron I'm having the same issue
@@withlovefaith Difficult to solve as I can see it. Have you tired by using the Edge browser?
@@websquadron I have not, I'm currently using Safari. I'm going to play around a bit to see if it's my browser or if I'm missing something else