Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Related (but not the same): Open Excel files in new window

If I've got an instance of Excel with multiple documents open in the same window. Is there a way to "tear off" one of the windows in the current running instance of Excel so that it's in an entirely different window?

What does not fit the bill:

  • Arrange all/view side by side/other MDI stuff; I want a separate window which can be maximized separately on another monitor and is managed by the window system differently, etc.
  • Saving/closing it in the running instance and then opening a new instance of Excel and opening the file there (this is what I currently do, but it's a pain)

edit: target Excel version is 2007 and up, though anything will do

share|improve this question
    
Can't help you but I've seen both in Excel: Everything in one window (MDI like) and each sheet one window. Did you check the prefs? Maybe it's an option? –  Aaron Digulla Apr 26 '11 at 19:35
1  
@Aaron that may be acceptable and would at potentially be better than what I've got now, but I'm not seeing that option anywhere –  Daniel DiPaolo Apr 26 '11 at 20:50
1  
Microsoft be damned for locking me into a single Excel window! Isn't your OS called Windows - plural? Welcome to Window 7! –  dunxd Jun 13 '12 at 9:36

2 Answers 2

Interesting idea. I'm reasonably confident that you cannot do this without a custom macro. Being a rainy Sunday...

Sub OpenInNewInstance()
     Dim objXLNewApp As Excel.Application
     Dim doc As String

     doc = ActiveWorkbook.FullName
     ActiveWorkbook.Close True

     Set objXLNewApp = CreateObject("Excel.Application")

     objXLNewApp.Workbooks.Open doc
     objXLNewApp.Visible = True
End Sub

Assuming you're not familiar with VBA, you'd need to:

  1. Copy the code above
  2. With a new Excel workbook opened, open Excel's VBA editor (Alt+F11)
  3. Right-click on VBAProject (Book1) (or whatever it's called in the left menu)
  4. Select Insert > Module
  5. Paste in the code into the main window
  6. Back in Excel, select another workbook to test the code on (it'll save the workbook before it closes it)
  7. Go back to VBA editor, select the module you pasted in and press the play button

I have 3 versions of Excel installed on my machine, and when I run this in Excel 2010, it opens a new instance of Excel 2003.

If this suits your needs, you could package this into an add-in and have it available as a ribbon button. Let me know and I can help out if you're unfamiliar with doing so.

Edit: If this approach works for you, obviously there would be some additional code to add in that would ensure the new instance of Excel is maximized in another window. Let me know.

share|improve this answer

To open 2 instances double click the first file you wish to open. Once that is open go to start/programs/msoffice/excel and just open another instance from there. Then you can use File/open It works for me. If it doesnt have a look at the Folder Options>File types, XLS, Advanced & check the Open form.

share|improve this answer
    
I specifically mentioned that I already do this. –  Daniel DiPaolo Apr 26 '11 at 22:37
    
Ok apologies I was getting my windows and instances mixed up. And I suppose that you have tried maximizing excel across both monitors and then view-->new window which allows you to manage that window separately? –  Dave Apr 26 '11 at 22:51
    
View > New Window just creates a new window within that same instance, not a new non-MDI window. –  Daniel DiPaolo Apr 27 '11 at 0:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.