Unable to open excel 2010 files in seperate windows

[Abel18]

I am using the dell inspiron laptop running with the windows 7 OS. i have started using the Ms excel 2010 and i wanted to open different excel application but i am Unable to open excel 2010 files in seperate windows Please help me out in this matter. I would really appreciate your help thanks in advance.

[Eric B]

I haven't used the office 2010 yet but i think that since the excel 2010 evolved from the Excel 2007 so most of the properties or functionalities of excel 2007 would be similar to excel 2010. So i think that you simply need to check the checkbox "Show all windows in the Taskbar" and apply these settings this will fix your problem for sure.

[Abel18]

First of all i would like to thank you Eric B for replying me also let me tell you that i have used the Excel 2007 prior to Excel 2010 so i was aware of the setting which you specified in your problem. It appears that this doesn't work in Office 2010 beta. Or maybe there's another way to fix it please help me

[Raine]

You can open the two different file in two different excel instances by simply starting two instances of excel 2010. So firstly click on the start menu and open the excel 2010 application and then open one of the desired file in it. Now simply try to open another instance of excel 2010 for the other file similarly.

[Sam.D]

If you are somewhat familiar about the VBA programming then you can try to use your skills in achieving this objective you simply need to write the VBA code which i have mentioned below in the VBA Editor and search for the PERSONAL.XLSB workbook.

Now Insert a new class module and name it as "clsApplicationEvents" with the following code:

Public WithEvents App As Application

Private Sub App_WorkbookOpen(ByVal b1 As Workbook)
   
    If (Val(.Version) > 12) And (.Build = 4514) Then
            .ShowWindowsInTaskbar = False
            .ShowWindowsInTaskbar = True
        End If
    End With 
End Sub

<br/>

Now open the  PERSONAL.XLSB workbook and insert this code
Dim AppEvents as New clsApplicationEvents

Private Sub Workbook_Open()

    Set AppEvents.App = Application

End Sub

[Macarenas]

To open different files in two different excel instances you will have to initialize two instances of the excel 2010 application individually for both the files. Start Excel from the Start menu once to open one instance then click it again to open a second excel instance. You can now use these two instances to open the files that you want to see.