|
Actually - your comment allows me the following artisanal response: I rest my case!
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "As far as we know, our computer has never had an undetected error." - Weisert | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
|
I seem to recall some sort of CTRL and click.
veni bibi saltavi
|
|
|
|
|
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
|
|
|
|
|
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. 
|
|
|
|
|
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
|
|
|
|
|
Of course, the .msi
Will do that instead.
|
|
|
|
|
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?
--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. 
|
|
|
|
|
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.
|
|
|
|
|
...because offering this as an option in the Options dialog in Excel is all too hard.
cheers
Chris Maunder
|
|
|
|
|
While they're at it, add a search box in there as well.
|
|
|
|
|
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.
|
|
|
|
|
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 
|
|
|
|
|
Speaking of programming questions in the Lounge...
I need a cutting edge language. Is F sharp enough?
... such stuff as dreams are made on
modified 20-May-16 7:22am.
|
|
|
|
|
"Elephant!", "Sunshine!", "That bl**dy hurt!", and "Medic!"
That's the cutting edge language I use.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
WTF#
New version: WinHeist Version 2.2.2 Beta I told my psychiatrist that I was hearing voices in my head. He said you don't have a psychiatrist!
|
|
|
|
|
Yes - but use Razor for the front end
|
|
|
|
|
I'd try to use python and put monty in the front 
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Didn't work too well for Brian or Arthur though.
|
|
|
|
|
you cannot make an omelette without breaking eggs
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Can't make a messiah without a naughty boy either it seems. 
|
|
|
|
|
None shall pass!
You always obtain more by being rather polite and armed than polite only.
|
|
|
|
|
If it is, V B doomed!
"You'd have to be a floating database guru clad in a white toga and ghandi level of sereneness to fix this goddamn clusterfuck.", BruceN[ ^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
