|
Chris Maunder wrote: Open 2 spreadsheets and they will always appear in the same MDI window. Completely useless on a multi-monitor setup.
Exactly the use case I was thinking of!
Marc
|
|
|
|
|
Try This Registry File[^]
I just created it based on some info I found (basically I disabled Excel's DDE usage, which is what caused the multiple documents in one instance issue)
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
Granted I currently use Office 2013, but I don't remember ever having issues with two Excel documents being viewed on two monitors ... or side by side on single for that matters
modified 19-Nov-18 21:01pm.
|
|
|
|
|
You can run multiple instances of Excel 2010 by shift-clicking on the Window's taskbar icon, and opening different documents in each of them (via drag and drop if you wish) but Excel barfs when copying data from one instance to another.
|
|
|
|
|
Run Excel.exe and then open another file.
Or on Windows 7, open the first file, then middle-click on Excel in the taskbar to open a second instance of it.
|
|
|
|
|
Ahem.
Options | Advanced | Display | Show all windows in the taskbar
|
|
|
|
|
Yep -that shows all child windows in the task bar, but doesn't let you actually treat child windows as separate windows.
cheers
Chris Maunder
|
|
|
|
|
Using this, I was able to move a different spreadsheet onto each different monitor.
|
|
|
|
|
Office 2010 or 2013?
cheers
Chris Maunder
|
|
|
|
|
Office 2010. I believe it was removed in 2013.
|
|
|
|
|
In that case it's being actively malicious in refusing to work properly. Curse your Office! Curse you!
cheers
Chris Maunder
|
|
|
|
|
Excel 2013 does remove the all spreadsheets in a single MDI container misfeature of the last 20 years of excel so you can view them side by side without needing to run multiple excel processes.
But it does something even worse instead. To be helpful it actively merges multiple Excel processes together. Officially this is supposed to be a good idea because copy/paste between two SSes in different processes doesn't quite work the same as copy/paste between to SSes in the same process, also "to make it work more like MS Word" (WTE that actually means). This is a problem because Excel still only has a single undo buffer shared among all documents and my second most common reason for multiple Excel processes is to get around that. Typical workflow:
0) Start making major changes to a table of data, and realize I need the before and after versions side by side.
1) Copy the updated table into a spreadsheet in a new process.
2) Go to the original file and Undo. Undo. Undo. Undo...
3) Copy the new table back to the original file.
2013 breaks this because it immediately merges processes and my first undo removes the copy in the temp file. I initially tried working around it by saving the temp file, only to discover that my undo buffer was completely emptied.
Fortunately a bit of Googling turned up the solution. Replace the "magic" shortcut created by the office installer with a normal one and add the /x command line parameter. Now all of my Excel processes stay non-merged just like they're supposed to.
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
|
|
|
|
|
Sadly not, unless you want to run one "Desktop" version and one "Modern" (i.e. Metro) version, from my reading. I believe MS sometimes use "Modern App" to describe a Store App/Universal App, whatever the **** you want to call that pile of steaming...
As I keep reiterating, if this is their idea of the future of Windows development, it may well be time to start reskilling on a different platform. I love the idea of Universal Apps, where most code can be shared between desktop/tablet/phone/HoloLens, but I don't like the restrictions that come with the only way of distributing an app to users (apart from in source form), except within an Enterprise.
That's (barely) acceptable for a phone or tablet, for a desktop O/S its just not acceptable.
If it was possible to set up a number of trusted stores/repositories, I'd have no issues at all.
(It's not even like its worked very well at keeping their own store free of cruft)
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
I read this as "Modern" apps in the sense of the UI formerly known as Metro.
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
I can already do that with windows: just don't use "Modern".
#SupportHeForShe If your actions inspire others to dream more, learn more, do more and become more, you are a leader.-John Q. Adams
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
Only 2 things are infinite, the universe and human stupidity, and I'm not sure about the former.-Albert Einstein
|
|
|
|
|
Windows XP is still hanging onto the No. 2 spot among all desktop OS Web traffic recorded by Net Applications in May. But together, Windows 8 and 8.1 outshine the 13-year-old OS. Better late than never
|
|
|
|
|
A new InfoWorld survey of software developers highlights their growing influence in business -- and their keen awareness of challenges going forward. "You can't control what you can't measure"
|
|
|
|
|
Say goodbye to Windows Media Center and control over your updates Your immortal soul Duh-dun-DUN! Oh wait, they've updated the EULA and removed that bit.
|
|
|
|
|
Never used Windows Media Center, and updates... Nah, never did. So, what should I say goodbye to?
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Although the Pro and Enterprise editions will both be able to defer updates, Windows 10 Home users will not have the option. Updates will instead be downloaded and installed automatically as soon as they're available.
I will absolutely refuse to install W10 if that's the case. I don't want it downloading crap, I don't want it updating crap. I await for someone to write a patch this kills this process, otherwise, it's a big F.U. to Microsoft.
Marc
|
|
|
|
|
Just don't use the home edition.
#SupportHeForShe If your actions inspire others to dream more, learn more, do more and become more, you are a leader.-John Q. Adams
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
Only 2 things are infinite, the universe and human stupidity, and I'm not sure about the former.-Albert Einstein
|
|
|
|
|
TheGreatAndPowerfulOz wrote: Just don't use the home edition
FTFY
|
|
|
|
|
#SupportHeForShe If your actions inspire others to dream more, learn more, do more and become more, you are a leader.-John Q. Adams
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
Only 2 things are infinite, the universe and human stupidity, and I'm not sure about the former.-Albert Einstein
|
|
|
|
|
TheGreatAndPowerfulOz wrote: Just don't use the home edition.
Yeah, I wonder what "defer updates" means. Does it still suck up my bandwidth downloading? Can I defer indefinitely or do I get constant reminders and a time limit?
Blech. As a developer, I want a stable development environment, I do not Windows updating itself!
Marc
|
|
|
|
|
Marc Clifton wrote: As a developer, I want a stable development environment, I do not Windows updating itself!
Which is why they expect you to be using Windows 10 Pro.
Kevin
|
|
|
|