Excel在尝试更新链接的SharePoint元数据时崩溃. [英] Excel crashes trying to update linked SharePoint metadata.
问题描述
你好！
我有一个SharePoint网站，当前使用基于SharePoint列表的自定义列来构建(即，它们需要是查找字段).我有一个自定义内容类型"，它使用其中的一些列来存放Excel工作簿.我写过 一个宏，以便某些字段将更新SharePoint元数据-但是，当我运行它时，excel崩溃:
I have a SharePoint site currently built with custom columns which are based on SharePoint lists (i.e., they need to be lookup fields). I have an Custom Content Type, which uses some of these columns, to house an Excel workbook. I've written a macro so that certain fields will update the SharePoint metadata - however, when I run it, excel crashes:
ActiveWorkbook.ContentTypeProperties("Zone").Value = Sheets("Calculator").Range(区域")
以前，我将自定义列设置为简单的下拉列表(而不是查找)，那时，我的宏起作用了.我可以回到该方法，但是，鉴于SharePoint网站的性质，我希望员工能够更新列表而不是 要求管理员更新列值...此外，很高兴能够在库中工作并单击选择以查看其详细信息.
Previously, I had the custom columns as simple drop-downs (not a lookup), and at that time, my macro worked. I could go back to that method, but, the given the nature of the SharePoint site, I want employees to be able to update the list instead of asking an administrator to update the column values... furthermore, it's nice to be able to work in a library and click on the selections to see their details.
我发现有一篇文章讨论了有关Access的此问题(https://support.microsoft.com/en-us/help/3200416/access-crashes-when-you-update-a-linked-sharepoint-列表).总而言之，它说问题之所以发生是因为发生了无限循环 寻找列绑定值-我试图通过将新值更改为项目ID#，并将".Value"更改为".ID"来解决此问题，但这些方法均无效.我还尝试禁用ScreenUpdating和EnableEvents.
I found an article discussing this issue in regards to Access (https://support.microsoft.com/en-us/help/3200416/access-crashes-when-you-update-a-linked-sharepoint-list). In summary, it says the problem happens because an infinite loop takes place will looking for a columns bound value - I tried to resolve this by changing the new value to the item ID#, and by changing '.Value' to '.ID', but neither of those worked. I also tried disabling ScreenUpdating and EnableEvents.
用于Access的解决方案是打开使用与Microsoft Access 2010及更高版本兼容的缓存格式".我想我正在寻找与Excel相当的产品，除非有人有更好的解决方案.
The solution, for Access, is to turn on the "Use the cache format that is compatible with Microsoft Access 2010 and later". I guess I'm looking for an Excel equivalent, unless someone has a better fix.
谢谢！
推荐答案
我注意到该问题与SharePoint网站中的自定义内容类型"属性和Excel工作簿宏有关.为了更好地解决此问题，我将线程移到SharePoint论坛以获取更多帮助:
I notice that the issue is related to the Custom Content Type property and the Excel workbook Macro in SharePoint site. To better resolve the issue, I would move the thread to SharePoint forum for more help:
https://social.technet.microsoft.com/Forums/office /en-US/home?forum = sharepointgeneralprevious
Hope you can find the solution there :)
这篇关于Excel在尝试更新链接的SharePoint元数据时崩溃.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
