Forum Discussion
"Customize how this embedded workbook will appear to others" option does not appear!
The option to customize how an embedded workbook appears to others may not be available in certain scenarios or configurations. Here are a few possible reasons why you might not see the "Customize how this embedded workbook will appear to others" option:
- Limited permission: If you have limited permissions in your OneDrive for Business account or the SharePoint site where the workbook is located, you may not have the necessary privileges to customize the appearance of the embedded workbook.
- SharePoint configuration: The option to customize the embedded workbook's appearance may be disabled or restricted at the organization or site level by the SharePoint administrator. In such cases, you will not be able to access the customization options.
- Feature availability: Microsoft regularly updates and improves its products, including OneDrive for Business and SharePoint. It is possible that the option to customize the embedded workbook's appearance has been moved or removed in a particular update or version.
To overcome this limitation, you can try the following alternatives:
- Use Excel Online: If your organization permits, consider using Excel Online to edit and share your workbook. Excel Online provides more customization options for embedded workbooks, such as setting the display options, selecting specific ranges, and adjusting the view.
- Embed as a link: Instead of embedding the workbook directly, you can generate a sharing link to the workbook and provide the link to others. This allows them to open the workbook in their preferred application (Excel Online, Excel desktop, etc.) and customize the view themselves.
- Adjust settings within the embedded workbook: Depending on where you are embedding the workbook (e.g., a website or SharePoint page), you may have some control over the display settings within the embedding platform. Explore the settings available in the embedding platform to customize the appearance of the embedded workbook.
If the options mentioned above do not meet your requirements, I recommend reaching out to your organization's IT support or SharePoint administrator for further assistance. They can provide insights into the specific configuration and limitations within your organization's environment.
Please note that the availability and functionality of features can vary based on your organization's settings, licensing, and updates.The text and steps were created with the help of AI.
My answers are voluntary and without guarantee!
I hope this helps!
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
- 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/
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?
- Dear All, the same issue is happening with me. I have a personal account and I am used to embed excel files in pages, but now the "Customize how this embedded workbook will appear to others." is not appearing. I tried myself to create the HMTL code as defined here, using existing templates, IA, and double checking with colleagues but it seems that not only the option is not appearing, but also MSFT is blocking the embed of new Excel files with the permission to edit. Is there anything that we can do? Regards
