嵌入Excel工作表 - 允许在不登录的情况下进行查看 [英] Embed Excel worksheet - allow view without sign-in
问题描述
我试图在我的页面中嵌入一个工作表，一切似乎都没有问题，除了显示消息：
I trying to embed a piece of a Worksheet in my page, and everything seems short of fine except that is shows the message :
SharePoint Online>>登录
SharePoint Online >> Sign In
深入了解oneDrive在线
looking deep into oneDrive online
（https://xxxxxxxxx-my.sharepoint.com/xxxxxxxxx/xxxxxx_onmicrosoft_com/_layouts / ....）
i无法找到任何方法来禁用登录对于工作簿
(https://xxxxxxxxx-my.sharepoint.com/xxxxxxxxx/xxxxxx_onmicrosoft_com/_layouts/....)
i can't find any way to disable the need of login in for the workbook
有趣的是，如果我建立了链接：
分享 - >任何有链接的人都可以查看 - >复制链接
Funny thing is, if I made a link:
Share -> Anyone with link can view -> Copy Link
并粘贴到同一浏览器实例上的另一个标签页，然后我就会看到原始的嵌入工作表
and paste into another tab on same browser instance, then I can see the original embed Sheet
所以...
打开隐身，用嵌入表打开我的页面，同样"登录"消息，在第二个标签中打开视图链接，刷新第一个标签，然后不再登录
opening incognito, open my page with the embed sheet, same "sign in" message, open the view link in a second tab, refresh the first, and then no more Sign-in
对我来说似乎是一个缺陷，一个错误，或类似......
for me seems a flaw, a bug, or something like ...
所以我的解决方法到目前为止，有点麻烦：
so my workaround so far, kind of cumbersome:
- 我制作了一张新单，只有"欢迎信息"。并且我设置（在Excel上离线）作为唯一一个启用的浏览器
- I made a new sheet, just only with "welcome info" and I set up (on excel offline) to be this sheet as the only one browser enabled
  （欢迎信息，包括一个链接回到我的网站）
(the welcome info, includes a link back to my web)
- 在我的网站上，一条消息："如果你看不到内容，激活链接"链接到"欢迎信息"的唯一视图版本
- on my web, a message: "if you can not see the content, ACTIVATE THE LINK" with a link to a onlyView version of the "welcome info"
所以用户，在他们看到嵌入内容之前，至少要通过excel一件事，有点难看...
so users, have to pass trough the excel thing at least once before they can see the Embed content , kind of ugly ...
---------------
---------------
几分钟后播放并且我的解决方法已经存在缺陷，为了能够嵌入某些内容，需要在浏览器视图选项中保持活动状态，因此无法保持"仅限欢迎"。每个人都可以看到，并且只能嵌入我的网页...
few minutes later playing and already a flaw in my workaround, to be able to embed something, it is needed to be active in browser view options, so not possible to keep the "welcomes only" visible to everybody, and the embed only in my web ...
（所以真的需要一个解决方案）
(so really need a solution for this)
- ---------------
----------------
这是一个重复的表格：
this is a duplicated form :
推荐答案
您好，
您是否在Excel Web Access Web部件中显示Excel工作表？
Are you display the Excel worksheet in an Excel Web Access Web Part?
根据您的描述，当您在页面中嵌入Excel工作表时，它需要用户登录才能显示内容。
From your description, when you embed a Excel worksheet in your page, it required users to sign-in to display the contents.
您可以尝试在IE的兼容模式下运行，然后检查此问题是否仍然存在发生。您还可以尝试将您的网站网址添加到 "Local Intranet"列表中。和"可信网站"在IE设置中。
You can try to run in compatibility mode of IE, then check if this issue still occurs. You can also try to add your Web site URL to the list of "Local Intranet" and "Trusted Web Site" in IE settings.
转到IE>互联网选项> "安全"标签>选择"本地Intranet">点击"自定义级别">在"用户身份验证/登录"下完全向下滚动 部分>选择"使用当前用户名和密码自动登录"。
然后保存您的更改。
Go to IE > Internet Options > "Security" tab > Select "Local Intranet" > Click "Custom level" > Scroll all the way down and under "User Authentication/Logon" section > Select "Automatic logon with current user name and password". Then save your change.
作为一种变通方法，您可以添加一个名为"Import Spreadsheet"的新列表，然后将您的工作表导入此列表，然后显示此列表您网页上的网页部分。
As a workaround, you can add an new list called "Import Spreadsheet", and then import your worksheet into this list, then display this list web part in your page.
祝您好运，
Allen Bai
Allen Bai
这篇关于嵌入Excel工作表 - 允许在不登录的情况下进行查看的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
