Adjusting the wrong entries may cause serious problems (no, I don’t mean “opportunities”). Step 2: Now, simultaneously press Alt + F11 to launch the VBA editor window.
#EXCEL OPEN VBA EDITOR 2013 CODE#
It will instantly take you to the code window of that. Never edit the registry without creating a backup. You can also open the VBA editor by right-clicking on the worksheet tab and click on the view code. When opening a new spreadsheet from within a file from File Explorer or by using File -> Open in Excel, the file still opens in the current Excel instance. Having said that, this method only works when you use the Excel icon to open a new spreadsheet. However, whilst this approach is inherently the most dangerous / complex, it’s the only one where you can make Excel open a new instance each time.
#EXCEL OPEN VBA EDITOR 2013 HOW TO#
It’s a great way to make friends with your local IT department and learn how to re-format your hard drive. I show this for completion, but be very careful working with the registry. You can force Excel to open a new instance by default. As the menu appears, hold down the ALT key and left-click on the ‘Excel’ menu option.ĭo note, this method does not show a pop-up dialog to indicate you have initiated a new instance. Right click on the Excel icon in the taskbar.
I offer you no less than four alternatives. So, if you find yourself stuck with Excel running a resource-intensive task, here’s how you can open a second independent Excel application in an instance (get it?). You could still open a separate instance: you just had to do it differently. However, Excel 2013 onwards never ignored its origins. You could link to sheets on other screens (something you cannot do with multiple instances. Microsoft made our lives easier by allowing you to put Excel on two or more screens from the same instance. With the advent of Excel 2013, we forgot this trick. To circumvent this, you opened Excel again et voila! you could have Excel omnipresent across your display surfaces. If you worked with Excel, all of your files had to be displayed on one screen (unless you were very inventive) – because they were all running from the same initiation of the program – an instance. However, Excel didn’t necessarily keep up with the price reductions. Working with multiple screens has been with us for many years as they have become cheaper to purchase and make it easier for us to do our work. In fact, you may not be familiar with the term, but you are probably aware of a workaround already. That’s because you are using what is known as the same instance of Excel.