什么使workbooks.cancheckout失败？ [英] What makes workbooks.cancheckout fail?

问题描述

这是简短版本...如果有任何其他信息可以帮助我，请告诉我。

Here's the short version... let me know if any additional information can help.

我有一个SharePoint文档。我有两个用户都在同一个安全组中，并且都可以访问该文档。

I have an Excel document on SharePoint. I have two users who both are in the same security group and both have contribute access to the document.

在一个用户上， workbooks.cancheckout http：// address / document）只要没有人签出，返回true。

On one user, workbooks.cancheckout("http://address/document") returns true as long as nobody else has it checked out. As designed.

与另一个用户 workbooks.cancheckout（http：// address / document）返回假。所有的时间。

With another user, workbooks.cancheckout("http://address/document") returns false. All the time.

用户可以直接从SharePoint检查文档，因此这不是权限问题。我相信它与Excel正在尝试与SharePoint交谈的方式有关。

The user CAN check the document out directly from SharePoint, so this is NOT a permissions issue. I believe it has something to do with the way Excel is trying to talk to SharePoint.

什么原因导致cancheckout返回false，有没有人有什么建议正在导致或如何解决此错误？

What causes "cancheckout" to return false, and does anyone have any suggestions on what is causing or how to fix this error?

工作用户正在使用Office 2010.破坏的是2013年。然而，其他几个用户，全部不在2013年有错误。操作系统是所有用户的Windows 7。

The working user is using Office 2010. The broken one is 2013. However, several other users, all on 2013, are not having the error. OS is Windows 7 for all users.

推荐答案

我有类似的问题。我要求用户从他们的桌面手动访问共享点门户文档，然后使用excel VBA程序。有用。如果您更改密码，则必须手动转到共享点并访问该文档，以便您的凭据存储在缓存中的某个位置。它是有线的，但这是他们的方式我解决了我的一个用户面临的问题。

I has similar issue. I asked user to manually access share point portal document from their desktop and then use excel VBA program. It works. if you change password then you have to manually go to share point and access that document so your credentials are stored somewhere in cache. It is wired but this is they way I resolved problem faced by one of my user.

这篇关于什么使workbooks.cancheckout失败？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！