How do I embed an editable Excel spreadsheet?
-
I have a spreadsheet that I have a embed link (Custom HTML) on a page on my website, but it wont allow numbers to be placed into the cells. I have used the following code.
<iframe width="1200" height="600" frameborder="0" scrolling="no" src="https://1drv.ms/x/c/dc1b98f7b813ad6e/IQQ6S2keZbzjRKUS13g5TgxoAe0gKoy_0yEnvBY4X3XJpfg?em=2&wdAllowInteractivity=True&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True&waccluster=GUK3&edaebp=&edaebf=ctrl"></iframe>But wont allow entry into two cells (cost of fuel and cost per litre) I have allowedinteractivity as true. Any ideas?
The page I need help with: [log in to see the link]
-
Hi George (@gappiah ). thanks for your steer. I had been trying it in a seperate browser, which I keep for testing, ie not logged into anything and got the same results as you. It turns out it was something to do with onedrive access settings.
I moved the file to a separate folder and changed the settings to available by all, which allowed me to change the embed settings in the sheet its self, which wernt updating before and now shows more settings than before (AllowTyping=True and ActiveCell) which are key for this.
I think it was to do with the file being in the root of my one drive which restricts access to anyone else, even sharing.
Thanks for you pointers. Much appreciated
You must be logged in to reply to this topic.