Windows 10: Use Excel workbooks on multiple desktops

Hello! The problem I’m having is I want to use 2 desktops with a different excel workbook in each desktop. When I open an excel workbook in desktop 2, my computer switches to desktop 1 and opens the excel workbook there with the already existing workbook. This is annoying. How can have 2 desktops open with an excel workbook in each?

submitted by /u/MobileUser21
[link] [comments]

:)

 

Can't open file excel 2010 in multiple windows

In Excel 2010, all workbooks open within a single application window. Click Arrange All in the Window group of the View tab of the ribbon for options to arrange the workbook windows.

If you want to open workbooks in separate application windows, you will have to start multiple instances of Excel:

• Start Excel and open a workbook.
• Right-click the Excel icon in the Windows taskbar and select Microsoft Excel 2010 from the context menu.
• A new instance of Excel will start in a separate window. Open a workbook in this instance.

Warning: when copying and pasting between instances of Excel , you lose some features that are available when copying and pasting between workbooks in the same instance of Excel.

 

Some but not all Excel workbooks appear in taskbar.

Welcome to Windows Ten Forums, ju severn and restexas.

Don't know why you're having the issue and I don't have Office installed on my 10, but have in 8.1. I also have not had that many Excel workbooks opened to know if perhaps there's a limit to the list set in Office or in 10. I worked more with seperate sheets in a workbook rather than separate workbooks. However, for now to keep you working without the distraction, could you open a separate instance of Excel and work with it that way? Somewhat of a PITA I know, but that may work for now until resolved.

 

Some but not all Excel workbooks appear in taskbar.


I have for example, five Excel workbooks open, four will appear in the taskbar when I hover over the Excel icon and one will not. This happens pretty much every day and with a wide variety of Excel files, not the same ones. I have not noticed the same issue with other programs but must admit I rarely would have multiple files open from other programs.

I have tried every option suggested on forums that I have read including unticking and reticking the box in Excel advanced options to 'show all windows in taskbar', also right clicking on the taskbar to 'never combine' (and although this is not really what I'm after, the workbook will not show in the taskbar either). None of these make any difference.

I have also tried opening the files from the open button, from the recently used files list and from the folder they are stored in but this makes no difference.

When I 'alt-tab through the open screens, the workbook that I cannot see from the taskbar will always show as the very last item after every other screen from every other program I have open, even when it is the last item I have looked at.

It's driving me mad as in my work I always have to switch back and forth between spreadsheets.
Can anyone help or has anyone else come across the same problem?