Picture the scene. During an intensive task in one spreadsheet, other spreadsheets cannot be used — because the resources are all tied up.
In fact, you may not be familiar with the term, but you are probably aware of a workaround already. Let me explain. 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.
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. To circumvent this, you opened Excel again et voila! With the advent of Excel , we forgot this trick. Microsoft made our lives easier by allowing you to put Excel on two or more screens from the same instance. You could link to sheets on other screens something you cannot do with multiple instances. All was good in the world again.
This is annoying, to say the least, when you are trying to compare two separate Excel spreadsheets side by side. While it is true that you an enlarge your main Excel program window then resize the underlying open spreadsheet windows to fit, this is a less than ideal solution in my opinion. In this article I will share with you a few ways to open multiple instances of Microsoft Excel so you can have separate Excel spreadsheets open on dual monitors.
This option assumes you already have an Excel spreadsheet open and want to open a new Excel window to open a separate spreadsheet file in.
A new and separate Excel spreadsheet window will appear. However in my specific case, I would need to apply this method very often, because I need to open at least two or more instances of Excel every morning day.
It works perfect. Thank you Rick, thank you! Dieter, thanks for leaving such a wonderful message! It energizes me to hear the registery-method helped you out so much. Save my name, email, and website in this browser for the next time I comment. Blog Videos Contact About. Table of contents 1. Open New Instance of Excel 1. Double Click on a File then hold Alt 1. Create a Custom Shortcut 1. Use the Run Window 1. Use VBA 1.
Application xlApp. Add xlApp. Related Posts. To distinguish between open instances, change the caption: application. Anyone figure out how to get it working on the 64 bit version? Thanks Reply. Great addition, thanks! Hi Joe, Thanks for your message. Rick Reply. Hey Gui, You got me a little excited there. Thanks for sharing anyway! Thank you, the Alt open method works brilliantly. Much appreciated. Hope this helps! If you're using Windows 7, open up Excel from the Start menu. This instance can stay on your 1st monitor.
The, simply go to the Start menu again and open up Excel for a second time. This will act as a completely separate instance that you can drag to your 2nd monitor. From each instance, you can open up whatever files you need to. I hope this helps. Joined Mar 18, Messages 8, Last edited: Mar 1, Thank you Clabulis for your recommendation. I will try this out and will let you know if this solves my current issue Jerry Sullivan said:.
Hi cyrilbrd, That will work in your Excel , but not in Excel A method that works for is to run a command line from the windows Start button: excel. Joined Jan 8, Messages You must log in or register to reply here. Similar threads B. Question Create a seperate read only instance of a workbook already opened.
0コメント