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 |
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.幸運的是,撤消檔案工作的罰款和一切恢復正常。