Excel 2007，一个实例工作导致其他实例挂起？我确信 2003 年情况并非如此
我正在 Excel 2007 中处理一些 VBA 繁重的工作表。在我之前的工作中，我们有很多工作表，这些工作表需要长时间计算（评估交易等），如果您完全打开另一个 2003 会话，它们不会干扰与彼此。
在 2007 年，如果一个 Excel 会话正在运行并且正在努力处理 VBA，那么其他 Excel 会话也会挂起。这是最烦人的，因为我什至无法在其他运行时在 VBE 中编写代码。
还有其他人注意到这一点吗？我使用的是 8 个 CPU 的工作站，但它还远远不够用。我唯一能想到的是，它们在启动时都会加载相同的 .xla，但我本以为每个 xla 都会位于单独的 Excel 会话中？
I'm working on some VBA heavy sheets in Excel 2007. At my previous work we had a lot of sheets which were calc-ing for a long period ( valuing trades etc ) and if you opened another 2003 session completely they didn't interfere with each other.
It seems in 2007 if one Excel session is running and is working hard on VBA then other Excel sessions also hang. It's most annoying as I can't even code in the VBE while the other runs.
Has anyone else noticed this? I am on an 8 CPU workstation and it is nowhere near flat out. The only thing I can think of is that they do both load the same .xla's on start up but I would have thought each xla would be inside the seperate Excel sessions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
无论您打开多少个 Excel 工作簿（一个版本），它们仍然都在同一进程中运行。如果一本工作簿需要该流程的所有资源，则所有工作簿都将遭受相同的滞后。
但是，不同版本的 Excel 不会相互干扰。如果您正在运行这两个版本，则可以将一个版本分配给特定任务，然后使用另一个版本。在 2003 年（也许是 2007 年），还可以在 Excel 已打开的情况下通过从“开始”菜单启动 Excel 来生成实际应用程序的不同实例，但已知这会导致错误，特别是如果您使用个人工作簿来存储宏或其他数据。如果 2003 和 2007 都尝试打开同一个人工作簿，您将遇到相同的问题。
No matter how many Excel workbooks (of one version) you open, they all still operate off of the same process. If one workbook demands all of the resources of that process, then all of the workbooks will suffer the same lag.
Different versions of Excel, however, will not interfere with each other. If you're running both versions, you could relegate one version to a specific task and then use the other. It is also possible in 2003 (and perhaps 2007) to spawn different instances of the actual application by starting Excel from the Start menu while Excel is already open, but that's known to cause errors, especially if you utilize a personal workbook to store macros or other data. If both 2003 and 2007 are trying to open the same personal workbook, you'll wind up with the same issue.