|
When will I be able to EASILY put two different Excel windows on two separate screens ?
There are at least billion of people who would like to do that on a daily basis, and still no solution. (There are hacks, but geez, if I have to open another process each time it is a no go. One window = one different instance, changeable using a setting). SDI rulez 
DAMN. 
|
|
|
|
|
Rage wrote: When will I be able to EASILY put two different Excel windows on two separate screens ?
It is easy...you just need two machines.
|
|
|
|
|
Or even side-by-side on the same screen, I don't care...
I love Excel, but I have to agree with you: this is a PITA. 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Don't you just launch Excel from the start menu twice? That's all I do. Not ideal but hardly a massive effort.
|
|
|
|
|
No, I double click on files in Total Commander.
Opening the applications and then navigating to both files (our internal paths and directory structures have up to 17 levels) is a PITA, and actually soooo Windows98.
|
|
|
|
|
What's wrong with Windows 98? 
Geek code v 3.12 {
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
}
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
|
|
|
|
|
About 15 years...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Rage wrote: Opening the applications and then navigating to both files (our internal paths and directory structures have up to 17 levels) is a PITA
Once Excel is running, just launch the second instance by right-clicking on its icon on the taskbar...? What am I missing?
Also, if your files are that deep in some hierarchy: Shortcuts.
|
|
|
|
|
dandy72 wrote: What am I missing?
Even with two open instances, you need to navigate to your file to open it. make it a SDI application, one double click on a file opens it in a separate instance, et voilà. What is so complicated ?
|
|
|
|
|
I do this every day. I have 3 monitors. Sometimes I have Excel in 3 separate monitors.
All you need to do is open 2-3 distinct instances of excel.
I'm sure I don't understand your post, because I would think you could figure that out? 
|
|
|
|
|
In my case this is how it works by default...
Windows 7 (it makes the same in 8.1 and in 10)...
Office 2013.
When I double click an excel file I get another excel instance opened automatically.
Also I can just open it again from the start menu.
Also I can middle click the excel task bar icon.
In all cases I get another instance of Excel and therefore I can put it into another display by moving the window (mouse or Window + right arrow...).
Which Excel version do you have?
|
|
|
|
|
I have Win 7 and Office 2013 and that does not happen to me. You must have configured it differently somehow. Not sure how though.
|
|
|
|
|
Sure not... I've just got this laptop since one month or so and I don't remember making anything special to install office... 
|
|
|
|
|
I went on searching after posting the OC, and it seems that this goes better in 2013 (provided the option has been checked). I have 2007 and 2010. I will install the new version.
|
|
|
|
|
Not quite. In 2013 you don't have the all spreadsheets in a process share the same top level window limitation. You DO however still have all the other all spreadsheets are in a single process limitations; and out of the box 2013 is worse in this regard in some ways. Notably, and this is one that would enrage me enough at times that even when I didn't need to look at two XLSs at the same time I'd run multiple processes, all spreadsheets in a single process ahare a single undo buffer. Meaning that if you:
0) Open 2 spreadsheets.
1) Make a change in file 1.
2) Make a change in file 2.
3) Make a change in file 1.
4) Hit under twice in file 1.
Will undo the 2nd change in file 1, the only change in file 2, but still have the first change in file 1. This generally would bite me when I started editing a table and realized I was making enough changes that instead of being able to comfortably show them with strikeouts/different font colors (Word style track changes in Excel please).
With 2010 and prior I'd open a new temp XLS in a different process paste the updated table to it. Hammer undo in the original, and then paste the updated one back next to the original.
2013 broke this workflow. By default it has a helpful feature where if it sees you have two excel processes running it combines them into one and terminates the second without closing any of your files. This does have some benefits because copy/pasting between processes loses some things that can be copied within a process (although why they couldn't just make in/out process copy/paste work the same is beyond me) and reduces resource requirements; but it wrecked my workflow and initially left me thinking that the only workaround was to save my temp to disk so I could subvert the retarded unified undo buffer.
Eventually I found out there was a flag /X I could pass the shortcut on my taskbar to force it to launch a new process that wouldn't be merged instead of cluttering my computer up with temps I'd never remember to delete.
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
|
|
|
|
|
Undo does suck in multiple Excel files.
|
|
|
|
|
The name for Android 6 has been announced: Marshmallow. Let's look ahead and start planning the future: Android 7.
I suggest Android F. F as in 'Froot Loop'.
Any better ideas?
Kitty at my foot and I waAAAant to touch it...
modified 19-Aug-15 6:25am.
|
|
|
|
|
Given my previous experiences with Android I'd call it Smelly S..unshine.
Geek code v 3.12 {
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
}
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
|
|
|
|
|
E like Elephant was already used?
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
den2k88 wrote: Given my previous experiences with Android
?? What happened ? I've been a happy user since the beginning, so...
|
|
|
|
|
On all af the devices I had it, ranging from low-end cheap devices to top-ranking half-a-month-pay phones it turned out to be an instable memory and battery hog, crashing at least twice a day, failing to make phone calls and terribly slowing down after some months.
And I do not use apps except GMail and Facebook, not even Whatsapp.
I switched to Windows Phone and I find it way better. It is fast, never crashed and has a proper battery duration.
Geek code v 3.12 {
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
}
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
|
|
|
|
|
|
Not even I believe it - but what if I say that IE for Windows Phone outsmarts every other browser I used?
It's amazing how differently Windows and IE behave of phones and on desktops.
BTW: I'm using W7 sinc 4 years and it NEVER crashed, with a handful of exceptuions due to hardware failures.
Geek code v 3.12 {
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
}
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
|
|
|
|
|
CBadger wrote: Windows... never crashed...
Some people will not believe that to be a sentence 
I usually ask these people how they like living in the 90s.
|
|
|
|
|
Mistral gagnant.[^]
Both a very good candy, and one of the best French songs from the last century.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/badger.gif)