Embedding code excel file fails/corrupt after onedrive update on 16th July 2024

Question

Embedding code excel file fails/corrupt after onedrive update on 16th July 2024

This issue shows on all computers/laptops and tablets used to access the web site typically

https://www.lata.me.uk/friday/highscores.html

The existing excel sheets do not display the correct Print Area selection but showing the full sheet including column and row headers.

Generally I customise the script to set the display as the Print Area, this option has always worked well.

Typical embed code used now.......

<iframe width="790" height="540" frameborder="0" scrolling="no" src="https://onedrive.live.com/embed?resid=639EC0015CF06C90%2110346&authkey=%21AAKW0QGga17PlzU&em=2&wdAllowInteractivity=False&Item='High%20Scores'!Print_Area&wdHideGridlines=True&wdInConfigurator=True&wdInConfigurator=True"></iframe>

As I say this code ignores the Print Area

Creating a new embed code as follows........

<iframe src="https://1drv.ms/x/c/639ec0015cf06c90/UQOQbPBcAcCeIIBjaigAAAAAAAKW0QGga17PlzU" width="402" height="346" frameborder="0" scrolling="no"></iframe>

The above code only displays part of the sheet, when I choose “Customize how this embedded workbook will appear to others” the script changes to…

<iframe width="700" height="525" frameborder="0" scrolling="no" src="?wdAllowInteractivity=False&Item='High%20Scores'!Print_Area&wdHideGridlines=True&wdDownloadButton=True&wdInConfigurator=True&wdInConfigurator=True"></iframe>

Note the src=”https link has been removed

Using this code in my web page shows a 403 Forbidden error message…..

So I am back to using the original code that displays the full sheet ignoring the Print Area

I have tested using various new excel files to rule out a corrupt file, viewed on various devices all having the same results.

I can only think the onedrive embed process is corrupt.

Platform.. Win 10 home addition, office 365

Your help appreciated in this matter

It seems almost impossible to find any Microsoft support to talk to....

Regards Trevor