Embedding Excel into Website requires login
Hello All, I am attempting to embed a file into our website, and am running into issues. I found another post here that seems to talk about PPT but this trick did not work for me. https://techcommunity.microsoft.com/t5/sharepoint/embedding-ppt-requires-sharepoint-login/m-p/265418 Maybe Matt Coats will see this below and have some other idea 🙂 Also this Microsoft post tells me to do something that doesnt seem available to me: https://support.microsoft.com/en-us/office/embed-files-directly-into-your-website-or-blog-ed07dd52-8bdb-431d-96a5-cbe8a80b7418 I created a link to an excel file where anyone can view it: https://troutvalleyassociation.sharepoint.com/:x:/s/TVAFileShare2/EbF7YhLzn2BGrLjwuk5ris8BP1TH99k62sEH8pKDEbwE9A?e=1qz1Oo This link works fine for anyone logged in or not logged in. But when I attempt to use this link as an embedded view it does not work without logging in <p></p> <div style="text-align: center;"> <p> <iframe width="1000" height="600" frameborder="0" scrolling="no" src="https://troutvalleyassociation.sharepoint.com/:x:/s/TVAFileShare2/EbF7YhLzn2BGrLjwuk5ris8BP1TH99k62sEH8pKDEbwE9A?e=1qz1Oo&action=embedview&wdHideSheetTabs=True&wdHideHeaders=True&wdDownloadButton=False&ActiveCell=A2"></iframe> </p> </div> <p></p> here is a page it is embedded on: https://www.troutvalleyil.com/test.html I can access the excel file without any issues If I use my browser that is logged into O365 then the web page works But when anyone who is not logged into O365 attempts to access this web page it does not work for them Any thoughts / ideas / suggestions?
Linked Excel Files in Sharepoint don't work when links update.
I have two excel files with links to each other, both saved in the same folder in OneDrive. Here is an excerpt of one of the formulas when I first created the links: ...SEARCH("IVC",INDEX('[Live Pipeline (v2.00).xlsm]Project View'!$A$1:$FZ$50... However after closing and opening the file, they all changed automatically to: SEARCH("IVC",INDEX('https://MYORG.sharepoint.com/Shared Documents/Sales/[Live Pipeline (v2.00).xlsm]Project View'!$A$1:$FZ$50 and changed so the value they return is #VALUE If I do a Find/Replace on https://MYORG.sharepoint.com/Shared Documents/Sales/ to remove it from all formulas, everything starts working again. I have read that this could possibly be solved by unchecking the "update links to other documents" box, however next time I open the document, the box is back ticked. Any ideas to what I'm doing wrong?