Sharepoint 2010库-使用中的Excel文件提示丢失 [英] Sharepoint 2010 Library - Excel File in use prompt missing

问题描述

团队

快速提问-我有一个Sharepoint库，其中已装有文件.该库中有一个excel文件，用作该库中所有数据的目录.我们正在使用Excel电子表格中的链接打开文件 在链接指向的库中.一切正常，但是更新文件的用户遇到了问题.如果该文件已打开并正在使用中，则不会警告下一个打开该文件的人该文件已打开并正在编辑. 在Excel或库中是否有我需要打开的设置才能做到这一点?

Quick question - I have a Sharepoint library that has been populated with files.  In this library is an excel file that is used as a table of contents for all of the data in the library.  We are using links in the excel spreadsheet to open files in the library that the links point to.  This is working just fine but I'm having a problem with users who update the file.  If the file is open and in use, the next person who opens it is not warned that the file is open and being edited.  Is there a setting in Excel or on the library that I need to turn on for this to happen?

推荐答案

Excel中有一些设置用于"

there is some setup in the excel to "allow changes by more than one user at the same time."

您可以尝试在excel文件中将其禁用.

You can try to disable that in your excel file.

https://www.techonthenet.com/excel/questions/shared.php

最好的问候，

安东尼

这篇关于Sharepoint 2010库-使用中的Excel文件提示丢失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！