Forum Discussion
RonnyG
Feb 26, 2024Copper Contributor
Excel embedded on web page - How to prevent access to background data
Hi
I have built in an Excel worksheet into my web page so that my guests can use it as a calculator.
I have protected the sheet and only given access to a few cells for the users to fill.
The Excel sheet is stored in OneDrive on my 365 Family account.
The PROBLEM is that a line of buttons becomes visible at the bottom which gives guests access to see the WHOLE workbook, with background data, formulas and all. (See attached picture)
I don't want that.
-How can I remove/hide these buttons, -or remove the access that I have described above?
Regards
RonnyG
- DJ_JambaCopper Contributor
I am experiencing the same behaviour 🙄
All other office docs are read only in the preview, but the Excel preview allows editing via the full view button bottom right as described by the OP.
Does anyone know if this is by design or a bug?
I.E. Is the preview supposed to be read-only for all office docs or not? - JKPieterseSilver Contributor
RonnyG You can remove the download link. But anyone who has ever used the developer controls of the browser can turn that back on by editing your html code. So this isn't very secure. See my page on this: Excel: Embedding Excel files on your website; Preparing (jkp-ads.com)
- RonnyGCopper Contributor
Thank you JKPieterse
I am a bit surprised of the low level of security.
Do you know of other known and better methods of embedding files into webpages, other than the "Onedrive" way?- JKPieterseSilver ContributorNo, I'm afraid not.