excel - excel - 一次运行多个工作簿

如何运行多个Excel实例?

时间: 原作者:

Excel不适合,通常,只要使用R或python,就可以大大简化事情,并且快千倍,不可否认,切换需要花费一些精力,但完全值得。如果坚持使用Excel,并想在同一台计算机上运行多个Excel实例,请考虑下面列出的4个选项。


1. Alt + Open Excel



The first, and also my favorite method is the ALT + Open method. It works as follows:


Right click on the Excel icon in the taskbar. As the menu appears, hold down the ALT-key and left-click on the 'Excel' menu option.


New Instance Excel - Alt Open - 1.1



Hold down the ALT-key until the below window pops up. Press Yes to open a new instance.


New Instance Excel - Alt - Open - 1.2


Tip: you can also hold down the ALT-key, hoover your mouse over the Excel icon in the taskbar and click your scroll-button. This has the same effect and takes even less clicks.



2. Run Window



One of the quickest ways to open a new Excel Instance is using the Run window. To do this:



 Click Start -> enter 'Run' -> fill in"Excel.exe /x" and press enter.


 Or on Windows 10: enter"Excel.exe /x" in the start menu and press enter.



New Instance Excel - Start Window - 2.1



A new Excel instance will open.



3. Use VBA



This method makes use of VBA. Run below VBA code to open a second Excel instance. Do note, this method does not show a pop-up to indicate you opened a new instance.


Sub OpenNewExcelInstance()



Dim xlApp As Excel.Application


Set xlApp = New Excel.Application


xlApp.Workbooks.Add


xlApp.Visible = True


Set xlApp = Nothing



End Sub



4. Edit the Registry: Force Excel to Open in a New Instance by Default



This section explains how to open each Excel spreadsheet in a new instance by configuring a registry key. From all methods, this one involves the most steps to configure. However, if you need Excel to open a new instance by default, this method may be worth your while.


Note: this method only works when you use the Excel icon to open a new spreadsheet. When opening a new spreadsheet from within a file by using File -> Open, the file still opens in the current Excel instance. The same happens when you open a file from within the file explorer.



原作者:
...