Problem with 'sort and filter' feature of embed codes in Excel Online

Question

So my question has to do with the Excel Online feature where you can share a spreadsheet and embed it in a website with the option of allowing users to sort and filter the data. 

It looks like this:

One of the options if you look closely is "Let people sort and filter" which is not checked off. In the embed code you can see "AllowInteractivity=False". The problem is that when I check "Let people sort and filter" the embed code changes completely - going from:

<iframe width="700" height="900" frameborder="0" scrolling="no" src="https://onedrive.live.com/embed?cid=dontworryaboutitEDFD383&resid=6BAA9620AEDFD383%21107&authkey=AFj3X8xq2U3IfDE&em=2&wdAllowInteractivity=False&Item='Sheet1'!A1%3AI32"></iframe>

to:

<iframe width="700" height="900" frameborder="0" scrolling="no" src="https://onedrive.live.com/embed?cid=dontworryaboutitEDFD383&resid=6BAA9620AEDFD383%21107&authkey=AFj3X8xq2U3IfDE&em=2&Item='Sheet1'!A1%3AI32"></iframe>

If I manually change 'false' to 'true' that doesn't do the trick so I'm not sure what to try next.

Any thoughts?

Answer 1

Hello,

Thank you for posting on Microsoft Community.

As this query is linked to embedding Codes in Excel Online, this issue would be best addressed in the Excel IT Pro forum.

For more assistance with this issue you may contact the Excel IT Pro Forum using the following link.

http://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly. They can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Thank you.