Embed Excel file in WordPress using OneDrive

Question

Hello.

I am trying to embed an Excel file into a Wordpress website using OneDrive. Everything seems to be working well when I open the Wordpress page, however when other users try to open the page the spreadsheet doesn't show up and there is a message appearing saying "Unable to display named item".

What am I doing wrong?

Thank you.

PROBLEM SOLVED! Look at the last message to see the solution.

Answer 1

Hi Edoardo,

You're welcome! It has been my pleasure assisting you with this.

Thank you for posting your solution here in the community forum. I'm sure it will be helpful for others who visit this thread with a similar issue.

If you don't have further questions, please feel free to mark this thread at your end and have a great day ahead!

Fix by Edoardo:

--

When I was creating the code to embed the file in the iframe, I always selected the option to show only the print area of the spreadsheet. However this would embed in the code the part "area_di_stampa" which is the Italian for "Print_area". Anytime someone with a device with an Italian operating system tried to open the link, it would work fine...but anytime their operating system wasn't Italian it would show them the "Cannot display named item" error.

I now show a selected interval, which is the same as the print area but I am specifying the cells instead of the print area and it works great.

--

Thanks again!

Regards

Nik

Answer 2

Hi Nik.

I followed all the steps and we are getting closer.

If I use a very simple file, like the one at this link, I can embed the file without problems.

https://1drv.ms/x/s!Am8HMmTr27oSg1npi-4dziEWOQb-?e=PRY6Nv

As soon as I use the more complex file I want to embed, I can see the file without issues but some public people can see it and others can't..

The link below the file I am trying to embed.

https://1drv.ms/x/s!Am8HMmTr27oSg3MWz7Dqys-CnE0N?e=3uLp5c

Thanks for your help.

Edoardo.

Answer 3

Hi EdoardoMolinari,

To further narrow down the issue, please create a sample Excel workbook in OneDrive and follow the steps depending on the OneDrive version you have:

1. OneDrive personal(Microsoft 365 personal/Family subscription) : https://support.microsoft.com/en-us/office/shar...
2. OneDrive for business(Microsoft 365 business): https://support.microsoft.com/en-us/office/embe...

The final URL should be similar to this one:

https://host/personal/user/_layouts/15/guestacc...

Please let me know the outcome, and I'll look further into this.

Regards

Nik

Answer 4

Hi Nik.

I followed exactly those steps to embed the link but if someone else access that page it gets the message saying "Unable to display named item".

However if I use the link that I get via "share file" the file doesn't appear in the iframe.

Any suggestions?

Thanks!

Answer 5

Hi EdoardoMolinari,

Thanks for your post on the community forum. I'm Nik, an independent advisor here to assist you with this.

May I know if you use the file Embed link or shared link to embed in the WordPress using OneDrive?

To Embed files directly into your website or blog:

1. Go to the OneDrive website https://go.microsoft.com/fwlink/p/?LinkID=251869 . You might need to sign in with your Microsoft account.
2. Pick the file you want to embed by selecting the check box in the upper-right corner of the file.
3. Select Embed at the top of the page, and then choose Generate.
4. Copy and paste the code into the code of your website or blog.

Also, ensure that you get the anyone link for the embedded file.

Regards

Nik