#Installing phstat in excel 2016 manual
#Installing phstat in excel 2016 full

Say you have an instance open and a file open in it. However, if you alter how you open the files, you can get a lot of the connection back. Obviously one can use F2 to transfer the formula, but one at a time, eh? This kind of difference makes a noticeable difference with VBA too. Copy a cell (a formula cell to show the difference) and paste it into an Excel file in a separate instance, it pastes the value, the same as it would if pasted into a browser or open-form document program like Notepad. So, let's say you want to copy and paste from one to the other. They share nothing, and know nothing about each other outside anything Windows connected or sharing that being part of the MS Office suite of programs offers. Those separate instances are, to Windows and Excel, as different as an instance of Notepad and Autodesk. Its OWN, unshared with the other similarly opened files. If just opened as files from, say, Explorer each will open in (of course) an SDI form in its own instance of the Excel program. THAT SAID, you almost certainly would like to do what you can to get the functionality you are used to (and that any sane person wants). They will be SDI whether you like it or not and you cannot overcome that. You cannot achieve getting all files opened in an MDI situation. How can I stop this? How can I get back to having all my files open in the same window? Microsoft should always give users a choice, rather than arbitrarily make things one way or the other.

#Installing phstat in excel 2016 full

My screens are full and I need to see my files all in one place.

#Installing phstat in excel 2016 manual

I understand that some people find this useful as a means of being able to see files side by side (for which I may run a separate instance of Excel, especially if one is on Manual calc and the other is on Auto calc), but to me this is useless and annoying like hell. This happens regardless of whether the 'Ignore other applications that use Dynamic Data Exchange (DDE)' box is checked or unchecked. With this new Excel, when I open a file, instead of opening on the same blank worksheet window I already have opened, it opens a whole new window somewhere else on my screen. I could easily switch between files either by using 'View/Switch Windows', or by hovering over the task bar and selecting the file of interest. Prior to this migration, when I first launch Excel it would open a blank worksheet and any file I would then open would show up in the very same window (and thus the same screen location). I run applications in Excel constantly and thus it remains opened all workweek in a set location on one of my monitors. I just migrated to Windows 10 (Excel 2016).