Share via

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

Anonymous
2015-01-12T22:43:53+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2015-01-13T14:51:18+00:00

    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.

    Was this answer helpful?

    0 comments No comments