excel共享工作簿_Excel 2010中的共享工作簿限制

excel共享工作簿

Last week, a client sent me a workbook that I created for them a couple of years ago. They were having problems with it, even though things had been going smoothly since we first installed it.

上周，一位客户给我寄了我几年前为他们创建的工作簿。 即使自从我们首次安装它以来，一切进展顺利，他们仍然遇到问题。

To see what was happening, I went into the Visual Basic Explorer, and clicked on the workbook name. Instead of prompting me for the VBE password, this error message appeared: Project Locked -- Project is Unviewable.

若要查看发生了什么，我进入了Visual Basic资源管理器，并单击了工作簿名称。 出现此错误消息，而不是提示我输入VBE密码：项目已锁定-项目不可见。

Well, that's not good news. It's hard to troubleshoot the code, if you can't get in to see it.

好吧，这不是个好消息。 如果您无法查看代码，则很难对代码进行故障排除。

项目不可见 (Project is Unviewable)

My first guess was that the workbook was corrupted, but I checked the Microsoft site to see if there was any other explanation for this terse message. I found this article: XL2000: "Project Is Unviewable" Error Message When You Try to View Project

我的第一个猜测是该工作簿已损坏，但是我检查了Microsoft网站，以查看是否有其他有关此简短消息的解释。 我找到了这篇文章： XL2000：当您尝试查看项目时出现“项目不可见”错误消息

Even though the article was written for Excel 2000, it solved my problem in Excel 2010. The project was unviewable because someone had saved the file as a shared workbook. Of course, nobody knows how or when that happened, but we can make the file work properly again, by turning off the shared workbook setting.

即使该文章是针对Excel 2000编写的，它也解决了我在Excel 2010中的问题。该项目无法查看，因为有人将文件另存为共享工作簿。 当然，没有人知道发生这种情况的方式或时间，但是我们可以通过关闭共享工作簿设置使文件再次正常工作。

要在Excel 2010中关闭共享工作簿，请执行以下操作： (To turn off Shared Workbook in Excel 2010:)

• On the Excel Ribbon, click the Review tab, and click Share Workbook
  在Excel功能区上，单击“审阅”选项卡，然后单击“共享工作簿”

• On the Editing tab, remove the check mark from "Allow changes by more than one user…"
  在“编辑”选项卡上，取消选中“允许多个用户更改…”中的复选标记。

• Click OK, to close the dialog box.
  单击确定，关闭对话框。
• Click Yes, to confirm the change.
  单击是，确认更改。

After making that change, everything worked smoothly again, and business went back to normal.

进行更改后，一切恢复正常，业务恢复正常。

共享工作簿限制 (Shared Workbook Limitations)

A few years ago, I wrote about the limitations and problems that come with using shared workbooks in Excel 2003. There were lots of comments, with most people agreeing that shared workbooks cause trouble. A few people were in favour of them though, and were willing to trade the limitations for the shared features.

几年前，我写了有关Excel 2003中使用共享工作簿的限制和问题的文章 。 有很多评论，大多数人都认为共享工作簿会带来麻烦。 不过，有少数人支持它们，并愿意为共享功能交换限制。

It's a couple of versions later, and there are still limitations and problems with shared workbooks in Excel 2010. Nothing seems to have disappeared from the list of unavailable features, but I noticed that the following new limitations have been added:

它是后来的几个版本，在Excel 2010中共享工作簿仍然存在限制和问题。似乎没有任何东西从不可用的功能列表中消失，但是我注意到已添加了以下新限制：

在Excel 2010中的共享工作簿中，您不能： (In a shared workbook in Excel 2010 you cannot:)

• Create or apply slicers
  创建或应用切片器
• Create or modify sparklines
  创建或修改迷你图
• Sort or filter by formatting
  按格式排序或过滤

The previous restriction on creating lists was changed to a restriction on creating Excel tables. You can't add them to a shared workbook, and you can't share a workbook if it contains tables.

以前对创建列表的限制已更改为对创建Excel表的限制。 您不能将它们添加到共享工作簿中，并且如果包含表，则不能共享工作簿。

To see the full list you can visit the Microsoft page on shared workbooks, and read the list of Features That Are Not Supported.

要查看完整列表，您可以访问共享工作簿上的Microsoft页面，并阅读不支持的功能列表。

仍然避免共享工作簿 (Still Avoiding Shared Workbooks)

So, even though Excel continues to get new features, nothing new is available in shared workbooks. I'll continue to avoid them. How about you?

因此，即使Excel继续获得新功能，共享工作簿中也没有可用的新功能。 我会继续避免它们。 你呢？

翻译自: https://contexturesblog.com/archives/2012/07/24/shared-workbook-limits-in-excel-2010/

excel共享工作簿