How to open a new instance of Excel 2007 workbooks如何打开一个新的Excel 2007中的工作簿
Posted on June 26, 2009 at 5:46 am张贴于2009年6月26日在上午05点46分
If you work with Excel a lot, you've probably noticed that each workbook you open doesn't create a new instance of Excel.如果您的Excel工作很多，你可能注意到，每个工作簿中打开不创建一个新的Excel实例。 There are not several tabs for Excel in your taskbar like for Internet Explorer or other programs.有没有几个标签的Excel在您的任务栏一样的Internet Explorer或其他程序。
Why is this and how can it cause problems?这是为什么呢，它如何产生问题？ For the most part, it's not a big deal and doesn't bother most Excel users.在大多数情况下，这不是一个大问题，不打扰最Excel用户。 However, it is a real pain when working with many spreadsheets and they are treated as a group.然而，它是一个真正的疼痛时，与许多电子表格和他们的待遇作为一个群体。
For example, let's say you decide to calculate everything on one spreadsheet.例如，假设您决定一切计算的一个电子表格。 Well, if you have others open, Excel will recalculate all of them too as if they are somehow related.那么，如果您有其他开放， Excel将重新计算所有这些也好像是某种相关。 If this is what you want, great, but if not, there's no way to stop it!如果这是你想要什么，伟大的，但如果没有，就没有办法阻止它！
That is until now!这是目前为止！ Luckily, there's a nice registry hack for Excel 2007 that will let you open each workbook in a new instance.幸运的是，那里是一个不错的注册表黑客的Excel 2007中，让您打开每个工作簿中的一个新实例。 This is also really great if you have multiple monitors and want to have multiple Excel workbooks open on different monitors.这也真是太好了，如果你有多个显示器，并希望有多个Excel工作簿打开不同的显示器。 Right now, all of them show up in one Excel application like below:现在，他们都显示在一个Excel应用程序一样如下：
However, it's much easier to work with when you have separate instances for each workbook:然而，它更容易与你有不同的情况下为每个工作簿：
Finally, if one Excel spreadsheet crashes and burns, none of the others will be affected since it's running in its own instance.最后，如果一个Excel试算表崩溃和烧伤，没有任何其他国家也将受到影响，因为它的运行在自己的实例。 You can easily get this functionality using registry editing files already created that will add a context menu to your right-click menu.您可以很容易地获得这项功能使用注册表编辑文件已经建立，将添加到您的上下文菜单中右键单击菜单。
You can download this您可以下载本 ZIP file ZIP文件 that includes five different files: one to add the option and make it default, one to just add the option, one to just make it default, one to remove the option, and one to remove making it default. ，其中包括5个不同的文件： 1添加选项，使其默认情况下，一个刚刚购买的选择，一个刚刚使其默认情况下，一个删除选项，删除一个使默认。 Note that these files only work for Excel 2007 running on a 32-bit Windows platform.请注意，这些文件不仅为Excel 2007中运行于32位Windows平台。
All of the files are TXT files and in order to use them, you have to just rename them to .reg files.所有的文件都是txt文件，并为了使用它们，你必须重新命名他们刚刚。 reg文件。 After that, just double-click on the one you want to use and click OK when the prompt appears.在此之后，只要双击您要使用，然后单击确定出现提示时。
Also, you can run the files in any order you like, so you can add the option to the context menu, then make it default, etc.此外，您还可以运行中的文件的任何命令你喜欢，所以你可以购买选择上下文菜单，然后使它默认情况下，等
The other thing to note is that you might have some issue with copy and paste because advanced formatting can only be done between workbooks in the same instance.其他需要注意的一点是你可能有一些问题，复制和粘贴，因为先进的格式只能簿之间在同一实例。 So if you need to copy and paste something between two workbooks that has advanced formatting, open them in the same instance using the normal Open command.因此，如果您需要复制并粘贴了两国之间的工作簿拥有先进的格式，打开它们在同一个体的正常使用Open命令。
If you have any problems, etc, post a comment here and I will try to help!如果您有任何问题等，张贴评论在这里，我将尽力帮助！ Enjoy your new freedom!享受新的自由！ [via [通过 ExpertsExchange ExpertsExchange ] ]
» Filed Under »文章属于 MS Office Tips MS Office的秘诀
 Save this page 保存该网页 |  Stir it up on Mixx 搅拌它的Mixx | |
 Add to Reddit 添加到Reddit |  Stumble this page 绊倒此页 |
Related Posts 有关职位
- How to add comments to an Excel Worksheet cell如何添加评论到Excel工作表单元格
- How to remove, crack, or break a forgotten Excel xls password如何删除，裂缝，或打破一个被遗忘的Excel xls密码
- Save time with copy paste shortcuts in Windows节省时间的快捷方式复制粘贴在Windows
- How to securely password protect an Excel file如何安全的密码保护的Excel文件
- How to edit the right click menu in Windows如何修改右键单击菜单中的Windows
GREAT, is there a way to do the same thing for Powerpoint?巨大的，是有办法做同样的事情，针对PowerPoint ？
How hard would this be to do for PowerPoint?怎么会这样做，针对PowerPoint ？
Surely there's a way to get this working in 64-bit versions of Windows?当然，有一个办法让这一工作在64位版本的Windows ？
After seeing this在看到这 on Lifehacker关于Lifehacker , I tried using the “Make Open In New Excel Instance Default” on Win7 64-bit and now I can't double click on Excel files to open them. ，我尝试使用“公开在新的Excel实例默认”关于Win7 64位，现在我不能双击Excel文件，以打开它们。 I have to right click and choose open.我要点击右键并选择打开。 And even when I do that, they're not showing up in separate instances.甚至当我做到这一点，他们不会出现在单独的情况。
Fortunately the undo file worked fine and everything's back to normal.幸运的是，撤消档案工作的罚款和一切恢复正常。