Make new Excel windows open only on the active desktop to avoid unwanted desktop switching.
The problem occurs when a saved file is double-clicked, opening a new window. The window will open on the active desktop if no other Excel windows are open. If, however, there are other Excel windows already open, the new window will appear on the same desktop as the last viewed Excel window. This can cause Windows to switch desktops, and result in the new Excel window appearing on a different desktop than intended.
This suggestion seems to be mergeable with https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/18010948-multiple-desktop-flexibility, and related to this one on minimized windows https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/16795765-when-opening-a-spreadsheet-when-excel-is-minized-d.
Peter Sutton commented
It is a highly irritating quality issue. I normally use a minimum of 3 desktops and frequently use Excel. This keeps me hopping around desktop to desktop. Surely MS is a sufficiently capable company to fix such a bad fault, almost instantly.
It also brings to the foreground an existing open document (even if minimised) in this process - this causes the desktop change.
BOTH foregrounding the existing files AND switching desktops are unwanted behaviours.
Excel also switches desktop, if I have a sheet open on a non active desktop and closes a sheet on the active desktop.