Forum Discussion

MichaelAkbar's avatar
MichaelAkbar
Copper Contributor
Jun 30, 2023

"Customize how this embedded workbook will appear to others" option does not appear!

I am trying to embed a range of my excel workbook but the option to customize how this embedded workbook will appear is no longer available.
CustomizeOption Not available
Waleedo's avatar
Waleedo
Copper Contributor
Jul 11, 2023

NikolinoDE    Hi.   

 

I have an individual Onedrive account which used to have the ability to generate and customize embed code (for excel worksheets that I wanted to embed in wordpress via html embed code).

Those options have been removed. I dont see them. I cant access them. This messes up my whole blogging strategy so I need to decide what to do next.  

 

I think (no one has confirmed it to me yet) Microsoft has decided to remove this functionality from "public" users of Onedrive. I dont have a business sharepoint account but I've heard the customize option is still available there. Can you verify this?

 

Getting a confirmation would at least allow me move on and come up with another strategy. 

 

Thanks and Regards, 

Waleed 

 

 

 

 

 

Plnio_Monteiro's avatar
Plnio_Monteiro
Copper Contributor
Jul 12, 2023
Waleed, I tried using the excel online and the using the commands: File --> Share --> Embed. With this option the "Customize how this embedded workbook will appear to others." is working! \o/
  • Waleedo's avatar
    Waleedo
    Copper Contributor
    Jul 16, 2023

    Hi Plnio_Monteiro , thanks.  Problem 1 done. Enter Problem 2 and Related Problem 3.

     

    I appreciated the feedback for sure. The Problem 2 is described in (B) below and Problem 3 in (C) below. Thanks again for any thoughtful feedback. 

     

    (A)

    Yes it looks like there are two ways to get embed code in Onedrive. (1) Select file (don't open just select) then choose "embed". In this mode you just get the iframe code with no customization option  (2) This time open the file itself and then "file/share/embed" to get the customization box. Now you can use the generated iframe code or the Javascript code (two choices). Cool. Problem 1 solved.    

     

    (B)

    One Weakness of the The iframe Code is Users Can Always Download the workbook:

    The iframe code works just fine in my web page and displays on both my Chrome desktop and my iphone. The one thing I don't want is to have the Microsoft linked bottom header (the black bar with the links titled "Information about the Workbook", and "View Full size workbook" etc. ) to allow people to download or copy my workbook. Any clue if there is a solution to this? The most popular answer I am getting is...there is no way to remove that bottom header or those links.  So, I decided to use the Javascript embed code. 

     

    (C)

    With Javascript embed code, I can view embedded file fine in Desktop but not Iphone !:

    Using the Javascript embed code in my Wordpress produces a viewable embedded workbook when viewing the web page from my Desktop. And, very nicely, the bottom header links now don't work so a person cant download or copy the file. HOWEVER, when I open the web page on my iphone, the embed workbook area is there but its blank (except bottom header is there). I tested this on another persons desktop and iphone with same results.  Any Clue about how to solve this one?

     

Resources