How to open separate Excel windows in W7
-
One of the more useful things I found this morning. https://support.microsoft.com/en-us/kb/2636670[^] Of course, I'm probably living in the past[^], still using W7. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
-
One of the more useful things I found this morning. https://support.microsoft.com/en-us/kb/2636670[^] Of course, I'm probably living in the past[^], still using W7. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
I seem to recall some sort of `CTRL` and click.
veni bibi saltavi
-
One of the more useful things I found this morning. https://support.microsoft.com/en-us/kb/2636670[^] Of course, I'm probably living in the past[^], still using W7. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Or you could just right-click on the Excel shortcut and click "Open". So I will open 2-3 instances of Excel on Windows 7 and 8, and open the file through that instance. A little tedious but it saves me editing the registry, etc. Windows 8 has the same issue, I believe.
-
Or you could just right-click on the Excel shortcut and click "Open". So I will open 2-3 instances of Excel on Windows 7 and 8, and open the file through that instance. A little tedious but it saves me editing the registry, etc. Windows 8 has the same issue, I believe.
Slacker007 wrote:
Or you could just right-click on the Excel shortcut and click "Open".
I forgot about that. Editing the registry means I don't have to remember (plus that link I posted comes with a small msi download that does the changes for me). Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
-
One of the more useful things I found this morning. https://support.microsoft.com/en-us/kb/2636670[^] Of course, I'm probably living in the past[^], still using W7. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Marc Clifton wrote:
Of course, I'm probably living in the past[^], still using W7
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.
-
Slacker007 wrote:
Or you could just right-click on the Excel shortcut and click "Open".
I forgot about that. Editing the registry means I don't have to remember (plus that link I posted comes with a small msi download that does the changes for me). Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Marc Clifton wrote:
Editing the registry
I'm actually going to try the steps in the link you provided - seems easier and more intuitive, IMHO. :thumbsup:
-
Marc Clifton wrote:
Editing the registry
I'm actually going to try the steps in the link you provided - seems easier and more intuitive, IMHO. :thumbsup:
Slacker007 wrote:
I'm actually going to try the steps in the link you provided
The msi download worked great too - actually, I didn't bother with manually doing it because I was lazy, but I did read the steps and I think I learned something interesting, not sure what though. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
-
One of the more useful things I found this morning. https://support.microsoft.com/en-us/kb/2636670[^] Of course, I'm probably living in the past[^], still using W7. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
...because offering this as an option in the Options dialog in Excel is all too hard.
cheers Chris Maunder
-
Or you could just right-click on the Excel shortcut and click "Open". So I will open 2-3 instances of Excel on Windows 7 and 8, and open the file through that instance. A little tedious but it saves me editing the registry, etc. Windows 8 has the same issue, I believe.
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. :doh: 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? --Zachris Topelius 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
-
One of the more useful things I found this morning. https://support.microsoft.com/en-us/kb/2636670[^] Of course, I'm probably living in the past[^], still using W7. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
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.
-
...because offering this as an option in the Options dialog in Excel is all too hard.
cheers Chris Maunder
-
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. :doh: 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? --Zachris Topelius 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
So what you are saying is that we should just stay with pencil and paper. :doh: :)
-
Slacker007 wrote:
I'm actually going to try the steps in the link you provided
The msi download worked great too - actually, I didn't bother with manually doing it because I was lazy, but I did read the steps and I think I learned something interesting, not sure what though. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Of course, the .msi Will do that instead.
-
One of the more useful things I found this morning. https://support.microsoft.com/en-us/kb/2636670[^] Of course, I'm probably living in the past[^], still using W7. :) Marc
Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Marc Clifton wrote:
I'm probably living in the past[^], still using W7. :)
I wish MS would live in the past a little more, maybe they'd make a good OS again :D
Read my (free) ebook Object-Oriented Programming in C# Succinctly. Visit my blog at Sander's bits - Writing the code you need. Or read my articles here on CodeProject.
Simplicity is prerequisite for reliability. — Edsger W. Dijkstra
Regards, Sander
