The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
Starting with Office 2013 that doesn't work the same. MS removed about half of the legacy WTF behavior from Excel in that version.
On the up side, documents within a single excel process are no longer trapped in the same top level window. This means you can have them open side by side without contortions.
On the both up and down side, they've added process merging. If you do the traditional contortions to create a second Excel process after a few seconds the two will be merged in the background and both your documents will be in the same process; just like if you opened them normally. The wins here are lower resource consumption and that copy/paste is richer within an Excel process than between two separate Excel processes.
On the down side, the undo buffer is still per process, not per document. This biting me is how I figured out stuff had changed. I'd semi-regularly start editing a table, realize I was making enough changes that instead of strikeout/red text that side by side before/after versions were a better way to show what changed. In 2010 and prior I could normally do this by copying the updated one to a 2nd process, undo spamming to get the original version back in the document, and then pasting the updated one in. 2013 made that workflow fail since the first undo would revert my temp file back to a blank document. The simplest way to work around this was to save and reopen the temp spreadsheet; but that left barf on the file system. The other option is to use one of the new methods[^] to force a 2nd independent process.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
No, my home laptop is W8.1, and I'm fine with it.. my family is comfortable with it and we see no need to move to W10.
For work, we use W7 (writing this from my work laptop), and it, do, does what I need.
I currently have multiple Excel spreadsheets open. One of them is a monthly report with various calculations, another is an iteration of the report using different inputs. Checking them for end-value differences to determine issues at the secondary source. They are opened in different Excel windows to allow me to have one on each display.
If you already have an Excel window open and there's an existing button for it on the taskbar, center mouse button click that Excel button on the taskbar to open a new instance of Excel. This works for most programs in Windows except things like Outlook that only want one instance running.