Feedback by UserVoice

Roy

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  2. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  3. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    And first half:

    They've refused to do anything at all to stitch two or more arrays together as one for my entire 32 years of time using the program.

    So I bet the answer is "Yes" but that they won't anyway.

    You CAN use INDEX and FILTER to do so, and you can have some complicated "geometries": not just the above/below stitching in the PNG, but you can use INDEX to extract, say, 10 columns, contiguous or not, from one table, then six more, say, from a second and have them match the row records in the 10 to their left (analogous to calling info from different tables in a real database), displaying to the right of the records that are in the 10 columns to the left. So looking like it was never abything but a single data source.

    You can even write formulas using IF to have FILTER(INDEX) look first to one table, then 2-3-4-... more to fill in those columns (11-16) for each row. So now you have maybe 3-4-5 actual data tables being drawn upon. That paradigm can be used in however a complicated way one needs to build a single data source.

    If that table is built in a companion spreadsheet that the user's working spreadsheet opens, it would be built right then from the most recent data, and, if the working spreadsheet has a FILTER(INDEX) construct based on it, it could be used for a variety of purposes and have gains for what functions one can use since it would be IN the working book, not in a separate book (analogous to the standard trick to use INDIRECT on a separate book, open or closed). Or the companion book's table could be used directly. The huge advantage of the companion book is that the data is "created" for use, then dumped forever when closing that book without saving, so the burden of duplication is avoided and also the human nature burden of the user being tempted to keep using an old copy, not the most recent material. One can also build his working book's table, if that is done, using INDEX to reduce the columns he has view of and access to. So the companion table might already be reduced to those 10 columns because it is for line supervisors and clerks, not management, but the workiong book tables for clerks might only have (not "show": "have") five of those 10 columns possible, and further ssecurity could be built allowing clerks tasked to do very particular tasks a table with seven, say, of the ten columns. But those entire 10 might be available to line supervisors. In any case, the fineness is kind of infinite, and something not usually achieveable in Excel.

    Also, if the user's book had such a working table built off the companion's fresh table, that would be what he further filers for his tasks so the original data that the companion's table was built from would never be "in use" and no table shared by anyone else would be used by a given user, so Excel's formal filtering rules functionality and its defects/limitations would NEVER come into play.

    The companion, being opened by VBA and controlled by it, need never be available directly to the user. Additionally, if you are doing this, likely you would create simple forms for any ADD or MODIFY work with the records so they could be VBA'ed into the original source, and the companion closed, and re-opened so the changes (and any from anyone else in the meantime) could be available immediately for view and review. The user might directly manipulate his working data table for research into his tasks or just to sell to your competitors, but would always be two steps removed from the source data. Only your VBA could affect it. He could never even see more than you were willing to risk him seeing to allow him to function much less wreck it with no more thought than a fly has, or steal it, or simply compromise some legal requirement concerning privacy.

    An error occurred while saving the comment
    Roy commented  · 

    Comment was too long, so second half first, then first half:

    None of that is usual for Excel.

    So, sadly, it's a little chore to do the above, though not that much, really, but not the simple task it would be if they created the functionality you are asking for. Since human nature is "I know, I read the above and really realize it is as easy as he says, not much work, but I have this problem with "much" when it modifies "work"... I... um...no. Just not doing anything like that." so we don't do the above in every office. That leaves our choices to be fullblown programs built for us or bought off the shelf, but expensive, doing the "not much work" in an actual database program with the STIFF learning curve involved and changing "not much" to "a LOT of", cobbling some ghost of it together in Excel and suffering the litany of known hassles, or not doing it at all.

    Or... moving to something that surely sounds like no work at all, just sneeze and it exists for you, I mean, no, not laziness, just wonderfulness... something like PowerApps... with 5-10 monthly fees coming to $480-$960 a year. For EVERY single task you do. So the five major tasks you do in your office every day/week/month for free since your Excel investment is sort of a sunk cost, are now EACH $500-$1,000 a year, or $2,500-$5,000 a year where they cost nothing if your function is created...

    So yeah, I think there's a HUGE reason MS won't change at least 32 years of history on this functionality. It's called "THAT MONSTER REVENUE STREAM" that's just a few forced steps away. If just 100,000,000 of the estimated 800,000,000 users in the world suddenly kicked in a new revenue stream of just $2,500 a year, MS, for almost no investment, would rake in a new stream of $250 Billion a year. Even a tenth of that would still be $25 Billion. "Bill-ionaire Gates" would be very aptly nicknamed.

    And whoever thought of it might get a bonus. That $10,000 for him might build him a really nice swimming pool.

    I admit to some jaded-ness on this subject, but the thing you ask is so easy and so incredibly useful (for much more than the above), but is going up against that $250 Billion dream. You have my vote, but I have no hope to offer you.

    Roy supported this idea  · 
  4. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    I use it a lot. Don't want ANY Ribbon.

    The Ribbon will reduce to what looks like a working menu system, so it's out of the way, but is is a nightmare Ribbon, not a working menu system and when we click on it, it's a nightmare to find anything. So, even that aspect sucks.

    I want a real menu system like we had before. Out of the way naturall, and lets me drill down to what I need.

    Roy supported this idea  · 
  5. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    The Help should tell this right at the start. Should've for 20-30 years.

    Roy supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    You CAN actually do this using a very old functionality.

    You must put the working part of the formula into a Named Range as the functions won't work right in the cells.

    The following website shows how in a very quick way. Good website overall, by the way. It is right, in a way, when it says you must use a macro, but only "in a way": the function used, which is extraordinarily useful, is from the versions of Excel that preceded VBA. In them, the functions were all handled as macros and so you could write macros that used them directly.

    https://excelribbon.tips.net/T010780_Colors_in_an_IF_Function.html

    If you use this, when you save, a prompt will tell you you must save using a macro-enabled format, like ".xlsm", but this is incorrect. Just save it normally, as a ".xlsx" file and you will be just fine. It triggers that message because of the above, how these functions were implemented, but they do not actually require a macro-format sheet, so no need.

    If you become interested in these functions ("EVALUATE" is one you hear about often enough, but not for the reason you should!), the following website is also a low-impact, honorable site and they publish a manual of the functions from the old days. 600 pages...

    EVLAUATE is a gem though, as it can do for a string expression converting it to a formula what INDIRECT does for a string expression converting it to a complicated address. So you can, if so inclined, have a simple in-cell formula based upon IF() that find formula pieces in a lookup table and uses EVALUATE to convert them to working formula and getting a complicated result from a simple formula. A table of formula strings is easier to maintain than a long IF(), especially if it is complicated. You know, if so inclined. Most folks seem to use it just fo change some string like "3+4" into 7. (Ah well...)

    tldr: look at the first link, use the formula, save as a regular file, all is good.

  7. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    Argue away.

    I'd point out that the breach of a five second look obtaining a woman's name vs. a five second look obtaining the idea that there's data on your screen and it might be organized into months not quarters are two very different things.

    And that if you allow longer looks due to general lack of regard for the environment not being "the office" (in which one often should not be allowing looking either), then you do indeed have an issue with stupidity. But helping a women get raped or stalked is hardly an appropriate punishment for simple stupidity. Being noticed by a boss and fired, sure, but raped and stalked? No, quite a little past appropriate consequences.

    If that iinformation is not shown, that would have harder time happening. If the password can be hidden, so can the user name. I have this problem in general with websites. Half the security is never hidden, not even an option to do so. Certainly programs should do better than websites which are, sad to say, often slapdash pieces of bits tooled together to sort of display things. Wouldn't mind programs like Excel not displaying filenames in the title bar either.

    An error occurred while saving the comment
    Roy commented  · 

    You're not going to win any points with men whose main pick-up line is:

    "Hey look, little girl, I could've just stalked you."

    (Got my vote. So many people doing things in public nowadays, at least some thought needs given to these areas.)

    Roy supported this idea  · 
  8. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    Sorry, still works properly for me. (I have Version 2004, Build 12730.20270 which is April's update, I believe. If we have noticeably different versions, that might be why. Maybe.)

    An error occurred while saving the comment
    Roy commented  · 

    I cannot duplicate the result, as described above.

  9. 1,275 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. …

    An error occurred while saving the comment
    Roy commented  · 

    @David Portwood: That's the thing, it used to be both so we all like the idea of just returning to the old scenario. Open normally, it's MDI and one Ribbon for however many spreadsheets you open. Those can't leave the "confines" of their parent window, but you can drag the window across all existing monitors so you can have any particular spreadsheet physically on whichever one you wish. Any file you open opens in that instance as an MDI-daughter, if you will, so normal click-to-open makes the file fully accessible to all other files Excel has open. Copy and paste works normally between them all and VBA switching/interaction between them is mostly seamless. One Ribbon means little screen loss to the Ribbon vs. now where you have a whole Ribbon per file.

    And if you want separate instances, which captures a ton of what people who prefer or value SDI want, you just Shift-Click to open and an entirely separate instance opens up. Desirable reasons for that? You need two files with the same name open at the same time (different paths). You want separate Undo stacks for each open file. You have a problem forgetting to Paste|Special|Values and face that thing where all the Named Ranges are imported or you have to use Task Manager to shut the instance down and lose any work and risk losing the file: separate instances are separae so copy and paste pastes values only no matter what pretty much so that can never happen. Lots of reasons, one supposes.

    HOWEVER, the truth is that the reason MS gave for the shift is so stunningly obviously false that it simply can't be the reason. That suggests they wanted to do it anyway and did. It suggests that they did so for reasons we'll never know. But since it was THEIR goal being served, you can be very sure hey've never considered changing back to the old version. At most to some version that cobbles some sort of MDI capability back on. And that the basic reason for that is they've done the things, or many of them, that gave them the reason to desire SDI themselves and ARE NOT going to ever change them all to work with MDI, and most likely some cannot without huge effort anyway.

    Me? I just want to clock-to-open utterly like I used to. I don't care if the engine underneath is SDI or MDI, I just want the results. Copy and paste, VBA between instances, it all should work like it did in a single MDI instance. Under NO circumstance EVER should a second instance open up unless I specifically command it to. Each open file can be SDI for all I care as long as they make the things I do care about work like they did in SDI. The Acres wasted by the eight Ribbons aren't even a problem in my mind. I don't care about HOW it "just works", just that the result for me day-to-day is right.

    Others here DO care about acreage taken by one Ribbon per open file. And so on. I feel for them because I don't think MS will do away with that. They were soooo proud that they no longer had menus (As-freaking-IF! A menu, even a useless one filling a third of your screen like their Ribbons, is still a menu!) that I don't think they'll let them be suppressed. Notice how they've made the QAT pretty darn hard to use easily? Yeah.

    So it's not really, probably, a matter of having both, ever. Just SDI that may address certain issues. (They HAVE addressed some of the issues I mentioned. I can drag something from Explorer onto the open instance and it opens, SDI to be sure, in that instance where when they first changed, new instances always opened regardless unless you used File|Open. So I think they'll keep after those minor fixes and some decade I'll be happy again. Not most folks here though, sad to say.)

    But I doubt we will ever see both available again, especially like before. So no worries for you, I don't think it's possible that could happen so you needn't worry when we "overreach" ourselves in these comments and such. Shed from their attention like water off a duck's back since they know it ain't never gonna happen.

    An error occurred while saving the comment
    Roy commented  · 

    Sheesh... those guys who wear tin foil hats ain't far wrong. Google Knows Everything™ and ain't slow with the C&D emails. Or bashful...

    Google Gigolo™ 'cause:

    Worthless Excel is to Google Sheets ("sheets"... see the "Crazy Eights-like connection" coming up?)

    as

    Worthless husband is to Google Gigolo™

    Geez... is this how kids feel with Santa watching their every move, making that list, and such?

    An error occurred while saving the comment
    Roy commented  · 

    I gotta try this one out on the wife...

    Instead of "You don't have to remind me every six months that I promised to fix that toilet eight years ago" I can just tell her "Your idea has us all excited. Please fill out our survey so we can assess your enthusiasm and real details of what you want. After playing this line for a year, we will move on to completely ignoring you for a year or two, then talk once for few seconds about how this has been moved to a planning stage to see if it can be implemented. Not "the" planning stage, just "a" planning stage. Then..." and we'll see if she is still on the hook and being played, or if she has moved on to some product of Google's perhaps.

    Maybe something called Google Gigolo™ with my luck, but maybe she'd still be on the hook like I am...

    An error occurred while saving the comment
    Roy commented  · 

    @Dale:

    Actually you can drag an Explorer icon onto the maximized window for Excel, wait a moment for it to stop saying no and indicate you can drop it and it will open nicely in the same instance. It is still not a/n MDI opening, they have their own ribbons and so on, but it is the same instance and that was with the window maximized. I do this all day long, drag and drop the icon onto the open Excel instance and it is always maximized. Always. I do NOT do teensy little windows all over the screens like MS seems it would dearly love me to.

    The hassle here is I used to be able to just click to open the Explorer icon and the above happened. Did not have to jump through so many hoops.

    Are you perhaps saying you get a/n MDI opening if you do explicitly what you say below? That would be interesting.

    What you can't do is drag a file from some programs, like Outlook, drop it the same way, and get the same instance. Of course, if you open a file from Outlook first off, before any other Excel work, then keep that instance open while opening and closing files, all the others (from inside Excel or via Explorer, even others from Outlook) will be happy to open in that one instance.

    But basically, it's broken still, just less inconvenient, because it always will start a new instance if you are not careful every single time, and because you never have MDI.

    All they had to do, if they were REALLY doing what they say they were doing, was to make the Shift-Click on the icon technique of forcing a new instance into a command line switch (like the "/e" we use to keep a useless new file from opening when Excel opens). Then those who "needed" SDI could have had seamless, effortless opening as they wished while the rest of us (the other 99%) continued on.

    Maybe that one change was why we get so poor response here and in other Suggestions. Not just the turds never replying, never updating, never saying anything that isn't mendacious, but such poor response concerning DOING the Suggestions. Maybe they did that one lickety-split, and it backfired so horribly with their reason for doing it looking so utterly stupid as to seem a flat lie, and it's "burnt their fingers" so now they hem and haw forever before making the least change.

    Maybe.

    Because that one was so incredibly, pathetically stupid if really done for the reason they've stated in the past. And don't even bother with anymore. So freaking stupid... or a lie from the beginning... not sure which they'd prefer we think. (Partly because I don't think they care what we think.)

    An error occurred while saving the comment
    Roy commented  · 

    (Sigh... )

    It used to be fun to poke fun at the advertising about "use Office whose programs all are built to work seamlessly with each other" failures. They never did more than Windows allowed anyway and they never will. But that's not even bruted about anymore so...

    It's still ironic though, that the lack of working together is so deeply rooted that separate instances of the same Office program can't even coordinate better than the chosen program and Jim-Bob's shoe shine app do. Usually, "ironic" usually includes "sad, so freaking sad..." and this is no exception.

    16 months... "You wait 16 months and what do you get? Another day older and... "

    An error occurred while saving the comment
    Roy commented  · 

    Wikipedia says (and it fits what I've read over the years):

    https://en.wikipedia.org/wiki/Visual_Basic_for_Applications

    "... implementation of Microsoft's event-driven programming language Visual Basic 6, which was discontinued in 2008 ..."

    (VB6 being the thing discontinued, not VBA)

    "... the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 ..."

    (apparently just added 64 bit support, though not complete support)

    "Office 2013 and Office 2016 include VBA 7.1"

    (nothing specified; just housekeeping for the new versions?)

    "... Microsoft intended to add .NET-based languages to the current version of VBA ever since the release of the .NET Framework ..."
    "... allowing even .NET-unaware applications to be scripted via .NET languages. "

    (always wondered why not when they ended VB)
    (oh, that would have been nice...)

    "However, VSA was deprecated in version 2.0 of the .NET Framework,[10] leaving no clear upgrade path ..."

    (oh... I see... )

    So, for now, I'd say our best hopes go with MS leaving the path open to other languages to write versions that, like Python to whatever extent, can replace, or work with/within VBA. That way, the onus is on others and their own development paths are not cut nastily short by decisions in other departments that they cannot really influence.

    As for this applying to our issue though, I'm thinking a laundry list of deficiencies will get made up over time since MS is NOT going to address them. With luck, they will become a list of reasons to use one language or another that might step into the void rather than staying an ever increasing list of reasons to revile MS and Excel.

    In particular, VBA was clearly never really pictured outside an MDI environment so there are definitely issues one might want to take note of in some of this Suggestion's comments. Flickering seems a small point (I know, important to the experience and some people's products) when compared to coordination issues that have been mentioned, for example.

    The bottom line is SDI creates what are in essence entirely different programs running in Windows and even though they are fellow Office programs (how much more "fellow" could they be?), it just isn't seamless and never will be, or would have been. Excel had a fantasy if they thought it could be. Drinking the "Office works seamlessly with itself" Kool-Aid does NOT make the advertising a reality.

    Evidence of that? Well, 30 years of living the dream... Of ALL the complaints in ALL the Suggestions you've all read, the sometimes complicated set-ups and uses of Excel, the writing of workflows maybe more complicated than many standalone software programs... of ALL those, when have you even one time read someone mentioning, even in passing, writing VBA code in Excel that reached out into other running Office programs to accomplish any task? Ever? On some other website? Some guru website telling you that your goal is best accompished by workign the material in Excel, perhaps, firing up Word to present it, and firing up Outlook to mail if off to 12,000 addresses. And using VBA from Excel, since it is the first program in the flow, to control it all, not just the Excel portion?

    No one even tries to suggest doing something like that. Not even MS. So just how well can we ever expect VBA to coordinate, safely and accurately, two or twelve instances of Excel, even if it is "just" instances of Excel, in order to work with all the files required by the work flow?

    Bring back MDI, allow one to set a choice, especially one available per spreadsheet rather than application-wide, and life is good for everyone.

    People who want separate instances could even have a "/switch" in the program shortcut (like the "/e" switch I just love). The complaint about moving spreadsheets between monitors was always spurious, though it is often said it was either THE reason for this, or at least the straw that broke the camel's back. Anyone desiring that could have always opened separate instances, or they could have normal-windowed Excel, drug its borders to cover the screen, then drug the appropriate one over onto the other monitor/s and moved MDI windows in the huge workspace. So even the rumored thing never needed a nuclear fix.

    It's all just sad and wretched. I'll eat a five pound pot roast with all the fixin's if it ever gets satisfactorily addressed. (I mean, I might do that anyway, but it's the thought that counts, right?)

    An error occurred while saving the comment
    Roy commented  · 

    Sorry, I wrote that badly:

    Physically set the monitors only once when setting up the computer. NOT every, every day! Just the shortcut keys once a day when logging on to match what Windows presents to the screwy physicality. Lordy, not moving the monitors themselves each day!

    An error occurred while saving the comment
    Roy commented  · 

    Too bad we can't rotate monitors 90°. Windows can be easily rotated too, in 90° increments, so one could just do that each day. Ctrl-Alt-(arrow of choice) and your computer matches your monitors in their "goofy" orientation. If I have to logon with a password to MY computer, I can do this without feeling put upon! (Well, one has to go to the Action Center once after buying the computer to turn on the use of those shortcut keys. Oh my, that does it!)

    When you'd need width too, you could spill the windows you tiled off the edge of whichever monitor so they cover both (the once a year I do this, I get columns A through AU). LOTS of columns too then.

    Oh well...

    An error occurred while saving the comment
    Roy commented  · 

    So many of the difficulties we are listing in here could actually be addressed individually by Excel, in ways that do not depend on MDI/SDI. Even the more involved thoughts, like if you open a file from INSIDE Excel, use Excel to do it (File|Open), not Windows (by Exploring to it and clicking, say), Excel could almost certainly easily keep track of those (it does now, build 1904, in that only one instance shows in Task Manager while using Windows to open the 2nd file shows two in TM) and if you tell it to, allow presentation of the files like it did for MDI, even though they are truly SDI, and provide a single ribbon at the top. So whatever window, maximized or normal, that it starts with, ribbon at the top that keeps track of which file you are in at the moment and acts upon it, like tiled windows and MDI did.

    Literally, how hard would that be? Probably? Not very since they can keep track of the files a single instance opened, and all the pieces are simply windows anyway so they can just work with the pieces differently, and use both those things to present it AS IF it were MDI. Who cares? Real estate-wise.

    Solve half a dozen of the little things without the major switchback to real MDI, like they did with the copy/paste issue the switch created but is now solved, and I bet ¾ of us could make nice-nice with it all.

    That could be seen as "divide and conquer" but it would be "responsive to customer needs" in my book.

    An error occurred while saving the comment
    Roy commented  · 

    (Sigh...)

    Remember all those years ago when MS and everyone else fell all over themselves proudly declaring they now had MDI enabled applications? Such a bright, new future we all were facing...

    It's like "1984"... OR IS IT?

    (Yes, it is.)

    An error occurred while saving the comment
    Roy commented  · 

    Bummer is, the part I wanted worked for one (1) day after I "woke up to" the 1903 Build. Then back to business as usual.

    "Woke up to" Build 1904 today, no joy.

    An error occurred while saving the comment
    Roy commented  · 

    Looks like 1903 is pretty up-to-date. I found an Office Insider person saying he has 1904.

    Interesting in its own way... Given your 1902 and my 1903, that may mean that 1904 will be rolled out next and contain the Spill functions, rather than it being more months.

    Maybe. But an interesting thought.

    An error occurred while saving the comment
    Roy commented  · 

    I saw the same, so "real estate" issues and the all open spreadsheets in the work area still seem to not be restored. One could probably use "Normal" windows now, for something like that, though on the Windows canvas, not in the old "workspace" below the menu, etc.

    If one uses VBA much, there are macros (fairly) readily available for positioning file windows exactly, and repeatably, so one would not have to do it by hand every single time.

    Of course, that probably could be done with multiple instances as well, maybe, but maybe not as a single macro but rather a set of one each per spreadsheet, but those instances could not have shared data like in the "old days" and almost certainly could not share macro services very well.

    Now though (see how has moved from "hope it's permanent" to "it's permanent" for me?), since they are all in the same instance, it might be a workable thing to set up.

    An error occurred while saving the comment
    Roy commented  · 

    @Mary:

    I seem to have: "Version 1903 (Build 11425.20228 Click-to-Run)"

    In human terms, it is Excel 2019 (I believe) installed from the Office 365 subscription the computer was set up with. The initial installation would have to have been Excel 2016, considering, and then updated over time. Other places here and elsewhere make it seem pretty solid that the version number is "19" and "03" as in 19 = 2019 and 03 might mean third update release, or March (third month) update release, or something of the kind.

    I cannot say concerning Access. My usage goes the other way, massaging data in Excel, then taking it into Access.

    An error occurred while saving the comment
    Roy commented  · 

    Reporting a change in my copy of Excel:

    Today I found, quite by surprise that a large portion of what I want concerning the MDI to SDI change has suddenly appeared.

    I had been unable to open multiple files in a single instance of Excel using all the normal methods (File|Open, click on a file in Explorer or on the desktop, drag a file onto the program window, open directly from Outlook). I could work around the Explorer issue by dragging a file onto the program window, but nothing would keep a file opened from Outlook from starting a new instance.

    But now ALL normal "person" opening methods open to the single instance. (Have not tested VBA or opening from other programs.) Task Manager reports only the single instance, I can close all of them by clicking the Taskbar icon and choosing close all, and I can copy and paste between spreadsheets just like between pages (formulas paste, not results, and so on).

    Since I have no indication as to WHY, I am planning on enhjoying the thought that it was some upgrade last night and is permanent. Honestly, I don't know that to be the case, but always have hope.

    If anyone is now seeing the same thing, perhaps some of the related difficulties people face over the change are also fixed, or at least accomodated if "fixed" isn't the appropriate word.

    On the other side of my "Hope balance"... I would expect an updated comment from the Admin for the Suggestion if it is a permanent change rather than a transitory one. I can picture it being an experiment rather than a final idea. That could lead either way: many of us like it and find our biggest problems taken care of so it ends up being permanent, possibly with further adjustments, OR, well, taken away. I will say that there is a noticeable lag in a file opening when clicked on in Outlook or Explorer, say 3-5 seconds, rather than pretty much immediately, which IS suggestive of a work in progress. (Note to Excel: if that can't be improved, I promise I CAN live with it for the functionality! Don't throw the progress out for that reason!)

    Bright, shiny day!

    Ooh... I'm going to try entering a number with leading 0's next, see if they remain! Either way though, BRIGHT, SHINY DAY!

    An error occurred while saving the comment
    Roy commented  · 

    Judging by some other Suggestions' comments from MS, I think Mr. Portwood's use of the word
    "last" is probably pretty spot on, though in a way we won't any of us find palatable.

    (Sigh...) Though I did see one for a different Suggestion that is less than a month old at the moment. So someone still looks at things here.

    An error occurred while saving the comment
    Roy commented  · 

    The new interface is like some 5yo's refrigerator drawing. "Crude" begins to describe it, but antonyms to "graceful" like "graceless" (not to mention "hideous") well describe the aesthetic.

    I guess they're saying today's new users, and the more recent ones like 00's Yuppies, I mean Hiptsers, have no sense of form and function that does not include the words "childish" and "garish"... so complimentary MS.

    I get that it was not written for me, that I share it with my closest 800,000,000 million friends. So the part that bugs me most is the losses of funcitonality. For instance, did a loss of beauty and grace really HAVE to include a loss of ability to work with sheets by navigating them? It would seem like they could have just made the tabs bigger, crayoned in them, and left the functional programming the same. But no.

    So the appearance, and its actually required (only given that you're shifting from fine point gel pens to Crayola's box of eight starter crayons with six of them removed) real estate losses (all the framework components can't get bigger without the real estate disappearing) are just sad par-for-the-course victims of marketing and "our product's too boring since it hasn't had a facelift in years" thinking.

    But what about that required going under the hood and ripping out functionality? ADD TO functionality? That's rather understandable. Rip it out? Not understandable.

    Here's a thought: How about the build the framework as its own unit, so to speak, with choices available for sizing it. So my vision is weaker nowadays? I set the framework to be at 120% the shipping version "normal" and so buttons are bigger, the ribbon is bigger, tabs are bigger, and so on. Jim would prefer 80%? Great. All that is smaller for Jim. And all the rest is real estate.

    What's the difference? NOW you can magnify or reduce the size of what is being termed "real estate": your actual worksheet space. The framwork stays how it came. So instead of reducing the infrastructure to increase the working space, all I can do is affect the sizing in the workspace.

    It could even be written to set the framework as desired, above, and when you activate a portion of it, say the ribbon, it would blow up from (or reduce to) your standard framework sizing to full installed shipping sizing.

    Lordy though, this current aesthetic is like that drawing the angry little daughter made of the family and Daddy says "Sweety, where's good old Daddy?" and she yanks it away and comes back shortly and points... we're just saying "Hey, MS sweety, where's good old User?" and they are angrily handing it back, pointing to the tombstone in the corner...

    An error occurred while saving the comment
    Roy commented  · 

    (Sigh...)

    An error occurred while saving the comment
    Roy commented  · 

    Enough digressing though.

    An error occurred while saving the comment
    Roy commented  · 

    Yes, hence part of the desire to break the spreadsheet into parts. You are going to be one of the data sources? Then yes, you can try to mangle my work (I, um, mean the company's work) to ease your pain but you only have access to one little corner and nothing else. So even if (when) you find a way to break things, it is easy to overcome.

    In that approach, the individual users have no real choice except to request changes and live with whether and how they get them. Naturally, politics often trumps good thinking, but at least they usually have to be done by the maintainer of the spreadsheet.

    Life is definitely complicated by everyday events and workloads though, and a busy creator sometimes has to leave modifications to someone else. These ARE company owned, not creator owned...

    For less important spreadsheets, life is more complex. Not being critical, they are less cared for... chewed upon.

    But approach them as if one is (slowly) normalizing an unruly database and life with them becomes easier over time. Work smarter, not harder, and one's productivity rises.

    Yep, I remember IRC. Had a six digit ICQ ID. I do not reach back to bulletin boards, never having liked them, but started out in '79 with a TRS-80 and have used phone receiver modems. Jumping Jack Flash seemed oddly primitive until I realized "banks..." And I remember all the little Hitlers pretending to love the freedom of the internet. Until we breed different people, that's not going away, whatever a thing is called. John Calvin is around every corner it seems. Even Stack Exchanges are going that way. (Sigh...)

    Neither here nor there to this I suppose. The shame of it is that something harder to manage and maintain is be forced upon us solely for the money. BG is in rapture telling us monopolies DON'T do that, but it is not only what they are doing here, it is what they do, period. Because we aren't, apparently, succeeding at breeding vile selfishness ("Mine! Mine! It is ALL mine!") out of humanity while preserving mild selfishness ("If I don't look out for myself, who will?" "You have a point there Bob, you do. And more to the point Bob, who should if not you?").

    What I'm saying is this is the future: there will be no fixing things, 1,000 votes or 20,000 votes, just a slow deprecation of Excel to something that can only handle an inventory list at home for insurance concerns. Figuratively. We shall overcome, like we have through the decades, but the pool we overcome is shrinking down, so to speak, to a kiddee pool. The kind adults look funny in, their b*tts wet, but arms and feet dangling outside. Ahh... metaphors... There will be no fixing, no returning to old functionality. Even freshly selling Excel 2010, say, is not in the cards because these people really believe every human would have to buy 10 copies of the most recent version if there is no other choice. Indians with annual incomves of $300 would pay $500 for Office if those pesky pirates would just go away (to the h*llhole prisons they of course belong in... right?). They wouldn't eat, as whole families, for two years just to do it, gosh, if it weren't for that. That kind of "thinking" just does not lead to good news for this kind of problem.

    An error occurred while saving the comment
    Roy commented  · 

    Absolutely. All sorts of flaws that have minor and sometimes major impact, but normalizing is an exceedingly useful concept, those DB people are on to something there...

    And it applies, or did, in the Excel world. For reference data, loading live data from various sources and types of sources, separating code into portions (or altogether), separating what is done with data (proprietary things especially) from sourcing the data, the list goes on.

    It all relies though, on the spreadsheets being available to each other and to VBA. Which is spotty at best in SDI.

    Of course, in a perfect world, one just puts a full spreadsheet together, makes it tick, works out the kinks and unexpected difficulties in the data feed and how people use it, and then management angels step in an hand over the cash to have programmers write an applciation that uses the essential approach, sources, people, and lessons of the spreadsheet. No boss calling you in one day and asking cold what specs such an app would need and your off-the-cuff reponses turning out to be the contracted for application. Rather a fully successful working better-than-prototype spreadsheet solution to inform the programmers every step of the way.

    Or the bosses ante up for an existing software that does the trick, after seeing how nice life is with a steady, accurate, safe, and private data flow is created and feeds your (proprietary) uses.

    So I am hardly opposed to seeing a treasured spreadsheet die by being replaced with an application. It's often the goal, really. But FORCED upon me? No, not so much... Especially when all that's really cared about is the new cash.

    And there are a million things we do that are "involved" but never rise to the "now let us write a program" level, if only because they are temporary needs (even, you know, "permanently temporary"), or fast changing, or just gradually become "involved" as one user or boss after another asks for this one little change. And "involved" means different things to different organizations depending on talents available at any given time. None of these situations cry out for writing a formal program, and the simple-minded things that are apparently PowerApps' focus are not necessarily on point.

    Additionally, managing a "normalized" spreadsheet is tough enough as the environment becomes complicated. Can you picture the management nightmare of, say, eight PowerApps apps that achieve the same-ish normalization? Managing them for results would be hard enough, but now picture managing them for not paying unneeded licensing fees.

    As to folks in forums... well... they might as well be religions, each one. "Choirs" at the very least, as in they are all "speaking to the choir." Each seems to have its set of absolute interests which must be nodded to, explicitly, and never, ever challenged. You might get lucky and post when a schism is imminent, but... those are not often. The self-validation they urgently need feels pathetic, but is in truth just sad. I avoid them mostly, have for a couple decades. Give a try when I'm optomisitc, but... it's also disgusting and I'm replacing lightbulbs with LED's that I will never have to replace again, so I don't have time to be interested in much of their cant. Good luck trying to swing any of them to a new view. It's like science: the people believing in (I, um, mean "who can prove continuous creation") continuous creation and who see the "big bang" theory (they even named it) had to die out before the big bang theory took the solid grip it has today. Overgrip actually, as there are actually some interesting explanations for some things if continuous creation is happening as well. That's physics. Imagine how that plays out in all other arenas in which opinion can have a role. Forums are almost nothing but opinion, so...

    Though if I need to know something, I'll suck it up and try again.

    Let me get in my daily thank you to MS for the wonderful world they just let us pay to live in.

    An error occurred while saving the comment
    Roy commented  · 

    And looke d at more starkly in my example, if you figure Excel was worth $5 out of your $12.50 (Outlook IS pretty important), MS would now have $285 a month, vs. the $5 a month, from the things you used to do with Excel alone.

    5,700% increase in revenue.

    People get bonuses for stuff like that. Not promotions, 'cause they can NEVER repeat that success, but bonuses, sure.

    An error occurred while saving the comment
    Roy commented  · 

    Here's the simple honest root of it all,no ifs, ands, or buts:

    MS wants to shift Excel away from being able to do anything much complicated or needing any real security or programming so that we all shift to PowerApps.

    Excel does a million things for a nice subscription price of $12.50 a month for a good version of Office. Well, a portion of that since you get all of Office and certainly use Outlook a lot and Word to some degree.

    PowerApps... that gets a nice subscription of $8 or so per month per application per user (including per designer).

    So you have 10 employees including yourself, all using Excel from an Office 365 subscription? That's $125 per month for "all you can use" (assuming they weren't silo-ing us into these newer, high cost applications and so made Excel useful and safe again).

    If you have five things you do, with an average of 7 users of the 10 using each one every month, they will now get $8 per month times 7 users each times 5 things = $280 per month for the five big things you used to do with Excel... PLUS the same $125 per month they STILL get because you still have to have the Office 365 subscription for not-the=five-big-things Excel uses, Outlook, and Word.

    So... by hammering us down to SDI so we cannot normalize our spreadsheets into a set for a task allowing better sfaety security as well as knowledge security, ease of use due to minimizing conflicts, reduced training by limiting a worker's interaction to what actually applies to him, and, by making each spreadsheet actually used smaller, having less load on the computers opening up he world of devices that can use the spreadsheets, MS is intending to force us into PowerAps, amongst others, raising the farming revenue they make, for no real work, by that example of $280 a months, tripling the example office's payout each month.

    Add in the required subscriptions to be able to share the app about ("publish" it) and access for maintenance of it, and you have raised the farming revenue even more.

    THAT AND NOTHING ELSE IN GOD'S WORLD is behind this SDI kick. Why do they not respond? They want such a future well-entrenched before we revolt.

    How many of you have been forced to consider the conveniently now available, oh-so-wonderful PowerApps subscription program as one of the alternatives we talk about below? How many of you are being told by bosses, who seem to be getting addressed on the subject outside of inside channels, "Look into PowerApps, it looks like something we need..."? I think Google, but worry, for good reason, they'll just drop their spreadsheet one day. They do that A LOT. No obvious reasons, just a thing is gone. But it isn't Google MS is angling at, it is PowerApps.

    PowerApps is meant to do every last little thing we keep complaining ("yapping" in MS-speech) has been lost and there is simply no coincidence to that. You sell the new bananas but people are reluctant to change? Buy some of the plantations and burn the crops. Pay other farmers to drop the crop for no rhyme or reason (Google) (yeah, that's anti-trust law there). Then begin sewing people's fingers together so they can't peel the old bananas and point out how the new bananas pop open with a mitten-paw squeeze and are oh-so-yummy. This is what monoploies do. Then they imitate Trump and simply tell some other story that also has no basis in reality and that's the life of the peons like you and me.

    Bitter? Cynical? F*ck yes it is. But it is also the absolute truth here.

    No nudge from me or from others has even bumped a comment out of MS. They're just happy "We the Sheeple" are busy forming a not in the least perfect Union. While they are opening new bank accounts as the old ones reach the physical limits of current bank software for recording balances. Sorry Ms. Gates sir, the account balance field is just a double integer field so you need several new accounts to hold the new money...

    Happy Days was a show created from a skit on Love American Style and Fonzi spent a year wearing a blue windbreaker. The story they all telll is utterly different. This is like 1984, things you did yesterday are now recorded as different than your memory.

    What we need to do is find someone who offers something like PowerApps, but works, not like the usual cr*ppy MS rival, and all go with that, smoothly leaving MS at the altar. Or talk to lawmakers. Every generation or so, that works a little.

    An error occurred while saving the comment
    Roy commented  · 

    And God forbid you split a task into multiple files so each person can do his part without affecting others and without everyone handling the real collection of information and program logic.

    Would MS prefer to give us real security (something the word "granular" could apply to)? Would they prefer to also give us the ability to segment a single file so each segment could limited to particular people and also give us the ability for true communal work (i.e.: real sharing/multiple workers using the file without miserable limitations?)?

    So no? Then let us open multiple files in the same instance without having to go to trouble about it and without all the attendant issues arising when that does not work out.

    I might mention there are a number of functions that will not reach into a closed file to extract data. They regard a file open in another instance as being closed. So they have to be opened in the same instance, utterly reliably, not in a sketchy (and useless) "sometimes people don't get a tricky thing like file opening right and it all goes to H*ll" way.

    Users DON'T get everything right, and the further up the food chain, the more effort one has to apply about that (I have weight issues so it's no surprise my metaphors involve the word "food"...). We all know that: bosses boss and they regard you as making excuses if they ***** up. File opening shouldn't be tricky anyway... FILE OPENING! How should the word "tricky" EVER apply to that? But it does now. Yes, I can make the files open with VBA which WILL put them in the same instance, but part of the reason for spreadsheets at all is to not have to program as much. And I have not tested how well VBA does without the Registry fix mentioned in the comments, and if it is required for VBA's opening of files to land them in the same instance, well...

    I must say though, I don't understand the real estate point mentioned:

    1) Surely you understand you can reduce the magnification to, say, 20% or 30% and all the real estate problems just go away!

    2) Surely you understand you can just upgrade everyone in the company to nice 50" or 60" monitors, like they have, probably, in every cubicle at MS, and the real estate problems just go away!

    Sheesh... must MS bear responsibility for everything??? Use the 30% magnification for those older folks in the office that would otherwise need reading glasses. They should be retired and enjoying the golden beaches of Tahiti anyway, no company should keep them as wage slaves after 35 or so anyway! Do them a bigger favor and fire them all. So really, that 20% level should be awesome, right?

    An error occurred while saving the comment
    Roy commented  · 

    @Anonymous:

    The bit at the end about the Registry entry is not correct. Many things in it are, of course, no argument. But the apparent purpose of it was to force Excel to ALWAYS operate that way, not only when the user did a special thing and by his distinctive action forced a new instance to open.

    There could easily be many reasons one might wish to do so. I myself would now and then to isolate spreadsheets from each other and sometiems in order to have more than one spreadsheet with the same name open at once. Perhaps someone would to have separate Undo stacks. Maybe they had formulas in something they were working on that would update from some second spreadsheet they had to open upon its opening, but did not wish that to happen yet had to open it anyway.

    Whatever though, it doesn't why they might've, they apparently needed it and asked about it and Excel's answer was, yes you can do that if you like, just make this Registry entry.
    Everyone else can keep on keepin' on, and you'll be happy too.

    HOW it applies to us today though is different as we represent a different part of the user base, one that wants the opposite and can't have it.

    What little it does for us is that it gives us back a few ways to get files to open in the single instance of Excel. So I can drag a file off my MRU list in Explorer and drop it on the instance of Excel I want it to open in. I could NOT do that before the fix. ONLY if I used the instance's File|Open function could I do so.

    So yes, it actually does bear on things here, and while it is no kind of argument for or against the Suggestion, traditionally folks in the Voice forum do not limit themselves to only such things, but also allow for helpful thoughts for difficulties expressed, even though that is not, of course, the actual purpose of this place. (If you like that kind of **** behavior, go to StackExchange instead...)

    I whole-heartedly agree though that there are contradictory desires expressed in here. My own comments decry SDI and cry the wonders of MDI. But as you can see, I agree with you that we should forget arguing about what's under the hood and express the functionality we need and a lack of appreciation for the functionality destroyed. We want a result and probably should evolve to discussing the results we desire without directly mentioning SDI or MDI. This would be natural since I think many of us are realizing some of what we want actually might be a bit SDI, not MDI.

    My understanding of human nature and my experience of general human intelligence says to me that there is no actual confusion about all this on Excel's part. Their people are surely fully aware of the things we want by now and capable of ignoring "yay SDI" and "boo SDI" commentary because they can realize we are perhaps thinking seemingly related changes came with that change and seem related and so mention them, but they aren't fully on point. They are curely able to catch on to that. But... counterpoint... you did not, so maybe they never, ever have in the years of reading these comments and talking to people and so on. I don't think so, no. But maybe.

    So I accuse them of "mendacity" and "neglect." I believe many others would harshen those terms and add "contempt" to the list. And it's well-deserved.

    But incredibly clear that MS misunderstood the requests? NO. Maybe for a week or two at first, but NO. They may still react ("trigger" in the modern parlance?) when anything SDI vs. NDI arises, but that's emotional, not intellectual. They're smart people and certainly as socially aware as myself, or a great deal more, and so much more than likely DO pretty much understand our points even if they trigger when seeing SDI/MDI popping up. There is 100% certainty they DO NOT 'clearly MISUNDERSTAND.' Bad feelings? Not care? Figure that we would think them meally-mouthed to explain they are bringing this or that back, but it's not really an SDI/MDI issue so...? Oh yeah, lots of that and more variants. But they simply do not "clearly" misunderstand. Maybe "somewhat" or "you folks are kind of confusing in small ways now and then" but not "clearly."

    I do think it's a good idea for us all to shift to saying the results we need, and/or the features we desire, since we may not have a full understanding of everything in the SDI/MDI thing. Just use MDI as a reference when possible.

    An error occurred while saving the comment
    Roy commented  · 

    Lol, they took " s..e..x..y.. buzzwords " and made it " **** buzzwords "

    But that loser who tells them to blah-blah-blah and lards it up with the "F word" sees most of the "F bombs" post. And then reposts them 40 times. Some programmers with heads up their backsides!

    An error occurred while saving the comment
    Roy commented  · 

    Two posts to get it all in since it seems there is a character limit (no, it doesn’t occur to me that maybe that means I should cut things…) Gonna post “halves” in reverse order so that it will hopefully read in the right order when seen together, though anyone following the thread will get email in which they come the wrong way. Sigh… yeah, I know trying to address two concerns at once is exactly where MS Excel’s programmers find themselves so there would seem to be some irony here…

    I should perhaps mention I hate the ribbon interface:

    1) I understand some people think "menu" is a four-letter word, in the worst sense, but the old menus worked like a charm. One thing they could have used would have been a right-click option of "Place on a quick access bar (single "line" button bar above or below the menu bar, say, with this single click of my mouse instead of the hassle I have to go through to achieve this now" so one could easily (literally, not in marketing speech-land imagination) have a bar of often needed commands. But whatever. This anti-menu thing was a religious thing, once upon a time, if you recall, with people hating to clock a menu choice then a sub-menu choice, then something else and a dialogue box opened with the real interaction... So now we have either a huge ribbon taking up real estate where one clicks a thing, not a menu, which opens more choices, and one clicks a thing, that then opens a dialogue box... but the priest says it's not what everyone hated about menus so it isn't, um, I guess...

    And now once has a hard time even learning Alt-shortcuts, when they even exist anymore. Yay religious fervor.

    2) One CAN reduce it to a menu looking thing, which I can't live without since I hate even seeing it at all nowadays (we evolve), and at least the loss of real estate is no more significant than with the menu bar it then looks like. But I'd prefer to get back the old menu interface, updated for new/newer commands and features, like Tables. With Alt-shortcuts always available and shown.

    3) I always hated the single workspace. I want the same functionality, but not that workspace bit. Talk about limiting real estate!!! Geez people:

    a) A single workspace with ALL your files sharing it? So you have four files open and somehow your real estate is greater than whole windows for files?
    b) You hate switching between windows? But switching between files that completely filled the workspace so you didn't lose real estate is different? (In concept... I know it's slightly different in some of the things that can interject themselves.)

    So whatever it takes to let me have separate windows rather than the single workspace is fine until it starts hammering and destroying other essential functionality.

    4) Just flat-out, the ribbon sucks. I hate it. Especially the huge space it takes and the very odd, in many cases, arrangement of features in it.

    I just want real, separate windows for the fact they give me a full window to work with, both sizing-wise and moving around-wise. One that interacts with the Windows Taskbar (which is the last time anyone will likely see me call it that instead of the incorrect "Start Bar" or variations on that). If SDI is required for that, then I applaud SDI.

    HOWEVER... since SDI apparently forces an incredible baggage train onto the program and utterly destroys big chunks of essential functionality, I don't want "it." Or at least, I don't want the ham-fisted, cut-the-baby-in-half approach taken to implement the single aspect of gain I see it having. I'd rather go back to full one workspace Excel than have what we have now.

    As to that Registry fix, it was apparently (based on the language at the Support site's way of putting things completely implying you wanted these things but currently did not have them, that it was written as if to an audience in that exact situation: certainly NOT the audience I am part of) meant to allow you to FORCE SDI upon your installation. So it was apparently written to ham-fistedly overcome what the audience did not like and creating the key with a value of 0, actively NOT seeking to do so could only keep the particular behaviors available from implementing the key from happening because of the key (with a value of 1).

    It, of course, was apparently not written to completely prevent those things, just not implement them because of the key... so if they were implemented in other manners, the key cannot help us. And if other programs (Outlook for instance) were updated assuming the full SDI concept in Excel, then abilities might not be available in the interaction (like how opening an Outlook attachment still opens a new instance, even with the fix).

    So... not a panacea. But better. A bit.

    An error occurred while saving the comment
    Roy commented  · 

    Seocnd half of the post:

    Bad sides of SDI that we are stuck with and need to be done with include everything arising from the multiple instances thing. Almost everything. So no, I DON'T want SDI, I want the functionality of separate windows. Everything else that's been mentioned, I want the abilities offered by MDI... but NOT in the world of the LITERAL single workspace on a single screen with thing tiled or lapped over each other or maximized within the workspace so one tabs between them, etc. I want the stupid things free, physically, of that.

    But why can't Excel do that? Offer the separate windows one can arrange over twelve monitors however one likes, each with some basic command bar (my precious menu bar of the past, or the hideous ribbon interface of today, with the minimization, only covering half the screen when you are actively using it, ability) so it has full usability, BUT with EXCEL still seeing them in a single workspace, just not requiring that they be displayed to YOU that way. A program doesn't have to see a thing the way it presents it to you any more than you have to make the screen jump around following a macro's selection of cells as it works on them. In fact, that's usually not the best thing, eh?

    But the files HAVE to be utterly and fully integratable. In the sense that MDI allowed. Not just (though it's an incredibly annoying loss!) allowing something as simple as full cut and paste but macro integration and formulas reaching into other files and so on. (I have a Suggestion out there, with no interest or support for it, sigh, concerning that whole silo of issues. Why should a function that can reach into another file for data require that file to be open when other functions doing the same thing can use closed files? Anyway, in separate instances, the file does not look open to those functions so... SDI strikes again.)

    To use an analogy, I don't care about the engine, I just want the CAR. And when I turn on the radio, I want it to work IN the car I'm in, not launch a new car in which it is working fine, but that has no air conditioning... that's running in a third car it launched... so I get the worst of all worlds.

    I just want to farm my fields and plant at the right time. I don't want to have to worship a pantheon of gods just to know what time is the right time for planting each year. I know many prefer that alternative, but I just want the functionality and don't care about the trappings. Office's original marketing point (not just theirs: even the horribly limited spreadsheet in Open Office's Harmony program from 37 years ago did the same marketing, before Office existed) was that you could more easily share between its programs. They did whatever they did, but YOU lived in the world of it all can flow between as needed without worrying about how they did whatever they did. I want THAT. I don't care what the techniques are the programs use, or the marketing, or the **** buzzwords: I just want the functionality. ALL of the functionality. No more ham-fisted muck-ups.

    An error occurred while saving the comment
    Roy commented  · 

    I'm looking for the following things:

    1) EVERY spreadsheet opens in the SAME instance of Excel. NO MATTER how I open them, every last method of opening them works like this and it does not matter where I open them from (including from inside other programs, Outlook being an example). ONLY if I intentionally force an new instance does one ever happen.

    2) EVERY one of them comes with a ribbon, etc., and looks and acts like it owns the world. (Better yet, bring back real menus and ditch the ribbon.) When they open, they open in their own windows which will be "normal" windows if I set it that way or maximized windows if I set it that way. There will be no tiling inside one workspace, or staggering, or whatever. They each get their own full window. If I wish to do side by side, I set that up.

    3) I have full and absolute interactivity between them. Only if I intentionally open new instances do I lose that full interactivity. That includes full value copy and paste, amongst other things, and full access via formula to any and all open files.

    4) I'd like a unique Undo stack for each but have lived 28 years without that so I can go a few days longer.

    5) Like any window, if I move it to another monitor, well, it's just on the other monitor. Nothing fancy needed, just Windows letting me move an Excel window around. I can do this because each file simply has its own window, NOT because someone chose the nuclear war option of forcing new instances. But to be explicitly clear: no returning to primitive days where the instance had a framework and a workspace and all the spreadsheets lived in the workspace... and could never be lifted out of it as their own windows.

    This is what I had using Excel 13 from an Office 365 purchase. IT couldn't make the 365 installation run on the new computer, so they dumbed it down to the Excel 13 version that could be installed instead. NOT 2010, 2013, no matter what people tell me.

    (Supposedly, I could not have had what I describe above, but I did. All with the Excel 13 available instead of the 365 installation.)

    For the time period I did try to use the suite's 365 version (it wasn't Excel that was unable to ever work safely with the computer), I experienced all the horrors I see today with Excel 16 (again from a failure of an Office 365 installation to work with a seriously plain vanilla Dell business computer). Then life returned to me. Now I'm stuck in this terrible place again.

    So... basically, it DID all work nicely as described above in the Excel 13 world which I am assured was 100% SDI.

    Which leads (finally) to the POINT:

    I don't really care about MDI vs. SDI, per se. I simply want the above, numbered, things just like I had them before when supposedly I had SDI anyway. I apparently had an SDI program, but had all the nice things about MDI which I list above. I just want the usability. MS can leave it SDI if they give me the usability I list above, back.

    I think most of us actually want precisely that and that some of the things said in order to attack and defend SDI are not really on point because apparently what is desired can be had in either situation. MS just has to return to accomodating MDI usability like they did in whatever version of Excel 13 they let one use if dumbing down from a 365 installation.

    (Not only did it tell you it was Office 13, it had formulas introduced in 13. So... Possibly there were odd files and Registry entries that hung around from the 365 installation that made it a Frankenstein monster, but a friendly, happy one.)

    As to SDI defenders, when I first came here, while using that version, I saw endless things here screaming to bring back SDI. So there is a big support for it. That's why, since it seems SDI is not, perhaps, the literal failure point here but rather removed functionality riding along with it, that there may a culture of ignoring us on the basis that we might be fervent, but don't know what we're talking about. (Thanks, MS, for giving us the benefit of believing we have the capacity to be ignorant, if that is so. Not every software provider believes that deeply in their users.) If they think that, then there's really nowhere for them to take this suggestion.

    Frighteningly, the difference I see between 13 and 16 could mean they did not remove all the MDI-like functionality with 13, but as they put 16 together, they "cleaned up" lots. And that it could get worse and worse as further releases "clean up" even more.

    All I care about is the usability I once had, and need, and apparently even when I had a full SDI version. Not about MDI vs. SDI, per se.

    An error occurred while saving the comment
    Roy commented  · 

    @J ROGERS:

    Some of the MDI side of things still exists but needs a Registry entry. After someone mentioned it, and I created it, I eventually had the ability to open multiple files in one instance if I used File|Open or dragged a file from Explorer ONTO the instance of Excel that I wanted it in. I can also achieve that opening a file with VBA.

    However, most of MDI is swept away even still. For instance, find a file in Explorer and click on it? Opens a new instance. I can drag it onto the running instance of Excel, drop it, and it opens in it nicely, but click on it and it opens a new instance. And in no circumstance I've tried can I open an Outlook attachment by dragging and dropping (MDI effect): no matter what I've tried, they open a new instance of Excel. Maybe using a macro?

    Anyway, the Registry edit is from a MS Support article and does give some MDI functionality back:

    Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options

    DisableMergeInstance

    Value to give (DWORD) = 0

    The Support article is:

    https://support.microsoft.com/en-us/help/3165211/how-to-force-excel-to-open-in-a-new-instance-by-default

    (You may notice it was designed, apparently, for an MDI world in which one might want strict SDI, hence a positive value for the key forces SDI only. Hence the need for the value to be zero.)

    Again, it doesn't bring my world back to being right, but it does restore some of the MDI world to me.

    An error occurred while saving the comment
    Roy commented  · 

    Folks aren't really aware of how change happens in many arenas... Science for example: the new ideas are never really accepted by most of the folks who preceded them. They have to work with them to keep their jobs, but like Einstein, NEVER accept their win and work as much as possible in their old paradigm. They move from the front line (teaching, working in labs) to administration and slowly to retirement. Then they die.

    Like it or not, this is how Big Bang theories, etc., eventually are the only thing taught, or largely so, and called "mainstream."

    LOTS of arenas, this is precisely how we (grudgingly) progress. Consider how it works when the results of experiments, and whatever stands in for experiments, are more a matter of opinion than clear and absolute (seeming) fact.

    Point of mentioning that?

    It's kind of looking like we will see one of two outcomes here:

    1) With no promises or updates, one day a new version will come out that restores MDI, whether tubing S(ucky)DI, or giving us a direct option.

    Yay! I wait the day!

    or

    2) MS just... never does do that... tosses an ADMIN comment to us every two-three years... (look at Pavlov's set of experiments: you'll be stunned at how long those dogs would salivate at the bells after the conditioning was set (or consider Cleveland Browns fans)) and just... NEVER does restore MDI.

    Figuring, of course, that like so many arenas of human life and endeavor, if they just wait it out, what? 30-60 years?, that all of us who ever knew MDI could even exist will die and then there'll be no pushback on the subject at all.

    Playing the "long game."

    I know which one I'm coming to believe it is.

    So... and I'm not there yet, but... alternatives. And as I've said before here, if I do significant work on that front, I will change and of course, never come back. I used three spreadsheets before switching to Excel and never returned to any of their predecessors after moving to each new one.

    When someone gives you an absolute "Pick from these one choices" edict, picking choice three is ALWAYS the way to go. If it weren't for Google's perfectly understandable willingness to utterly drop a whole idea the moment they determine it might not have a future, I actually would have switched already. That risk though... it's significant. "Pick from these zero choices" is even worse than what MS is offering.

    And finally (this comment, not forever, lol, seriously, right?) given how they are pushing the add-on programs like BI and the quick programming via Power Apps, I think they really want to break us from using Excel for anything other than quick and dirty databases with all the "fancier" work being done by one subscription app after another so they can add a pile of cash onto the initial purchase or basic subscription price. Honestly, breaking easy connection between sources and therefore the ability to separate a process into several spreadsheets so one interacts with only what his role needs to interact with, not fixing the Undo stack issue, ever, and giving VBA fits... at the very same time one is offering things like Power Apps and BI... it just smacks of a plan that is NOT NOT NOT going anywhere any of us want it to go.

    Ever watch the You-Tube videos of Bill Gates explaining how monopolu power allows a wonderful, beneficial organization like MS to force development of the future along just the right path instead of those nasty fits and starts and dead ends the riff-raff come up with? Ah, those wonderful idealists at MS. And Apple. And Exxon. And so on... where would we be without them and that sweet, sweet use of monopoly power?

    So... yeah... there's an old saying about sh*tt*ng in one hand and w*ish*ng in the other and see*ng wh*ch one f*lls up f*rst. MS is helping us with the "one hand"... will someone like Google step up and promise their spreadsheet will exist in twelve years? Not everyone left Eqypt in the Exodus, but enough did to keep a whole kingdom running for a few hundred years.

    An error occurred while saving the comment
    Roy commented  · 

    @Frank: That might be Windows, or MS apps in general. For me, Excel opens on the correct monitor, first of the day, almost always. Maximized nicely. Open a file then close when done? Pops over to monitor #2. (By the way, glad SDI solves multiple monitor issues, right?) Put it back and it stays put. However, the many times a second instance opens, it's the same cr@pshoot you see for which monitor it opens on. And whether it's maximized or not. And even if it IS maximized, the first window it opens (the one that persists if you just close the file, not the instance), sometimes called the "gray window" by people, is often a normal window trying to get lost in the shuffle and left open.

    All s*cks. But...

    I've noticed similar problems with other MS programs. Not precisely those, but Explorer, say, sometimes opens as an odd window for no obvious reason. Word? Never a problem. Anything else MS, whether Windows or Office, yeah, one odd behavior or another vis-a-vis the window the open, sometimes.

    Most obnoxious of course, are the subsidiary windows: password entry boxes, file saving boxes, pretty much any dialogue type window, find, find and replace, sort... you get the idea... ALL OVER THE PLACE. They stay in place for days, then all of the sudden hide away in some corner of the program window.

    It was using Acrobat (X, not that sh*tty DC version), its file export and import functions in particular though that suggested something other than the intentional forcing me to use a window if only for moments instead of everything being maximized unless I had a particular need to see two programs at once, though the second monitor solved that need forever — the intentional forcing of "normal" windows upon me that it seemed like MS was doing (As in: "Oh, if only the unwashed would JUST try them, they'd understand how wonderful sh*tty little windows all overtop of each other are! Then they'd sing their praises and use Windows the way God intended it to be used!") — that something else might be happening.

    It was a glitch in Acrobat that suggested Windows, running on a computer that puts any I had before it to shame, now needs maybe 5-10 seconds to close out actions it takes involving files. I've experienced this for years now, not just the latest computer so it happens with regular hard drives and with SSD types and it happens at the computer level at home as well as with networked files at work. I just never focused on it before.

    If I gave Acrobat a 5-10 second count before the next click, its glitch went away. Completely. Not ITS glitch: it's the underlying file operations of Windows, of that I am convinced.

    With the exception of the monitor jump that ALWAYS occurs when I close the first file of the day in Excel (But not if I open a second one first using File|Open, even if I close the second one before closing the first one.) all of the things I hate vis-a-vis window sizing and location (for dialogue boxes) seem to be solved by making sure I remember to give Windows 5-10 seconds after closing a program before shifting to another or launching another. Basically, let Windows save final conditions for things, I think, before moving it on to another thing. I SHOULD have noticed this with IE, how if I re-launched it immediately (1-2 seconds) after closing it, it would abort deleting all the browing stuff it is willing to delete and turn the files over to the new instance rather than give it a set of its own while continuing to delete the old. Seems obvious in retrospect, but the Acrobat thing (not their glitch I am now sure) that opened my thinking.

    Hence my saying what you experience might be Windows jacking you with inexcusably slow file operations work that it aborts the moment you launch something new so it can concentrate on the something new. Once aborted, it doesn't seem to go back to it, especially if you're re-launching the program.

    Worse, given how MS now does the SDI thing, and you have constantly launching instances, some of which will persist (keeping a deathgrip on certain file operations) because you closed the file, but not the instance, I think you're seeing Excel launching and seeing incomplete or contradictory garbage for loading and choosing the default ideas that make sense to the 75 windows overlying each other people in Redmond. Kool-Aid drinkers doing OUR thinking and choosing for us. Yay.

    Another way of putting it is that I think it's a MUCH larger problem than just Excel, though given Excel's extreme shakiness, its frailty, due to the SDI garbage-implementation, and its presence in EVERYONE'S day, we see it there, first and a lot.

    (That frailty actually disturbs me more than any particular obnoxious expression of it does.)

    An error occurred while saving the comment
    Roy commented  · 

    @Deanna... Please Deanna... broken up? Have you never seen a YouTube video of Bill Gate$ patiently explaining to us all why monopolies are incredibly good for an economy, and let's not forget, for a society?

    It seems that a monopoly can make decisions against the desires of consumers, for the better, of course, forcing them along the path from their current miserable existence to the shining future the monopolist, in his benevolence will allow them to have. I mean give to them, oops...

    'Against the desires of consumers' because they control the market and will still make tons of money regardless. The phone companies planned for us to be moving out of ISDN lines roughly now. That sort-of-128Kb transfer speed would still surely be better than today's 100Mb transfer speeds. If only we weren't so greedy, we could still be living their vision. Bad consumers!

    An error occurred while saving the comment
    Roy commented  · 

    Of course, John commented nine months ago and there's no update on anything, no rumors, no experiments forced on 365 users so... it just doesn't look good.

    An error occurred while saving the comment
    Roy commented  · 

    You had a window open for each file with a full set of tools. You could ALWAYS position them however you liked, move them to different monitors, tile them, cascade them, whatever you liked. Multiple monitors weren't any kind of issue if my plain vanilla equipment in XP, Windows 7, and now Windows 10 could do it.

    You could always open a whole new instance or three if you liked. Files with the same name, say.

    It wasn't like the old days when there was one window with the program interface (menus and such) and every file open had to share the real estate below that because they couldn't be drug out of the instance's basic framework window.

    So PRECISELY AND TRUTHFULLY, how was there ever an issue?

    Obviously, the Undo stack was shared by all the open files in the instance and that sucks, but that is a separate thing to fix.

    Then... SDI... Every file opened is in a whole new instance. Even with the registry fix, I can't open an attached spreadsheet from Outlook, their own directly related program, without doing it in a new instance. And others that I can open in the running instance have to be drug onto its window. I can't click to open them or... whole new instance.

    It is a nightmare. There are VBA issues. There are issues with files that depend upon each other. YOU try explaining to the boss that he now has a new level of difficulty to work with to use your nice spreadsheets. We used to be able to group spreadsheets and open them in sequence. Took that away. Very quick and handy it was. Now it's write a unique macro for every set or deal with the links that don't/can't update even though the files are open. In the context of this development, I have to think they took that away some time back because of things that led to this issue or because they chose to follow a path to here that along the way lost us this capability.

    Worse yet, the instances seem to be "owned" by the application that opened them. If I open an Outlook attachment and the new instance starts, I can keep opening Outlook attachments and they all open in that instance. That somehow has to be figuring into this as well.

    There is NO control over how the new instances open. So instead of maximized and on the monitor of my choice, they come up literally willy-nilly on their choice of monitor and always just a stupid "normal" window that I then have to maximize. Not to mention the dead one that opens and launches the new file. Sometimes it closes when I close the file, sometimes it stays. It is always present in the Task Bar, until closed.

    There is and was NO monitor issue unless it was very weird and almost certainly limited to a small slice of users. If plain vanilla has/had no issues, then there just wasn't an issue.

    I will note though, that we finally read something from John that is certainly true-ish. When I first came here, there was a steady whine, though NOT a roar, about having changed FROM SDI to MDI. Made no sense to me because it had never existed for me: My experience since the ribbon has all been what I described above, 10 years of it, until I got stuck with this version. Even 2013 was the good stuff though everyone says no it wasn't. Strange, that. But there were constant cries to return to SDI though they always petered out with a few votes. Sad that more than a few votes doesn't seem to take us back.

    Seems like it should be a choice in Options. Or at least with some registry fixes. (I'd be thrilled if the attachment opening could be fixed that way, or the dead window each new instance starts, or the window state when they open, or the whole having to drag because clicking would open a new instance thing... or all of them...)

    Hmm... maybe MS is trying to hide performance issues in Excel by forcing each file into a separate instance? Whole new set of resources... alleviating performance issues some? Fix this MS or you won't have any reputation left as we think of more reasons why you're doing this to us. And if you go the way of 123 and Quattro Pro, WE will write the story of miserable failure to consider your market instead of your own weird ideas. Right or wrong, just like those who wrote the 123 stories, we will write how it looked to us and then it, like you, would be history.

    Be nice if you chose a different fate. We DO actually like Excel, for the most part.

    An error occurred while saving the comment
    Roy commented  · 

    @Doug: Sorry to hear that... I would say though, for two reasons: 1) With it in the registry and set to 0 I at first thought it had no effect (the longer story is below somewhere) but eventually realized it DID have some effects, just not a wholesale changeover back to MDI. I could, for instance, drag a file from Explorer onto the running instance of Excel and it would open in that instance where without the key, it would not even open in a new instance. I cannot drag from Outlook, and maybe other places, oddly enough. However, before the key, if I opened a file and a new instance was created, that instance persisted after closing the file while now it 90% does not. I still cannot click on a file without a new instance. Also, files opened from inside the instance, say via a hyperlink, open in the existing instance where before they started a new one. So... maybe like me at first, the changes, not change, were not noticed because we were both looking for a "change" not "some changes for the better, but still sucky-ish"? And 2) The Support article does not explicitly say so, but strongly implies, it should work for anything affected from 2013 onward. Not definitive by any stretch, but maybe worth a shot.

    But if not, I feel for you. SDI SUCKS. And weird things seem to happen. And to think I used to think it was nice I could have it when I wanted it (say, for two files with the same name... another thing MS is pathetic about given there's no way on God's green earth it should present even difficulties, much less be utterly not permitted... you can't even achieve it by accident without a fresh instance of Excel) which wasn't often, but I wish now that no one at MS had ever had the idea cross his mind.

    Sounds like MS is beginning to look at Home the way some providers look at Evaluation copies. Sad, for something they sell for a pretty penny and certainly do not state is crippled.

    An error occurred while saving the comment
    Roy commented  · 

    Something I've seen as a topic here, bearing on the discontent with the subject, that I'd like to point out is NOT necessarily what people have said it to be:

    "The investment of time in switching to a new spreadsheet would be just so huge that I have to have satisfaction here, or live with suckiness forever."

    Well, for those not old enough to have gone through it, people said that about Lotus and Wordperfect once upon a time.

    More tellingly, Lotus and Wordperfeect said that about Lotus and Wordperfect.

    What are those programs? Something used in WWII to break German codes? Maybe Apollo used them for the lunar landings? No. Those programs were given to us by God as the only things that could ever be used, but they are gone now. Admittedly, a large part of that was an aspect of monopoly power, but I'd say Google, at least, is in a position to do the same thing. And guess what? Their spreadsheet is free too.

    MS had better get it right. I ditched 123 for Quatro Pro, learning curve be d*mned and then Quattro Pro for Excel because they broke them, literally, broke and not paying bills, but still learning curve be d*mned. I gave up Locascript for WordStar and then Wordstar for Word, learning curves be d*mned. All of them lesser programs, at the time of shifting, than what I had been using.

    And another for the record: the competition uses Windows, unlike MS in competition back then so no advantage to MS there. Arguably, because I hate it, but have no power to change it and it must change to this for society's sake anyway, the fact that Google has built to use the cloud (storage and app farms, to anyone who remembers Lotus and Wordperfect, "magic" to anyone who remembers Locascript and Wordstar) while MS is slumping its way there, in poorly conceived ways, and maybe not for another decade (the threatened sea changes in their engine, vis-a-vis the seven new wonder-functions, which it is hinted will make using older versions impossible as backward compatibility isn't part of the functions but rather a backward compatibility ("xlfn.") engine that is NOT mentioned despite being pretty revolutionary (and in place for a little while now) and that can be clipped out of the program in a second. With a SNIP... no more effort than that... no more backward compatibility.

    At that moment, several hundred billion spreadsheets would be dead... except that Google stands ready to help. Lotus and Wordperfect all over again.

    And in the coming move to a big iron cloud that you only interact with, seldom running things at your own desk, and having incredible implications for the cell phone market as well (important in itself, but also a thing utterly beyond MS control, which is how ideas win - Blu-Ray won the moment its capacity increased significantly as suddenly why would anyone buy a few hundred million computers with 60% of the optical storage - nothing to do with movies like the HD people aimed at - the whole second, unrelated market thing is massive in economics), Google is poised, like MS remembers itself, to go from a few percent of the market to 90% in a couple years, then enjoy 20-30 years resting on their laurels, milking it. If they make the milking choice, knowing their end would come similarly, someday.

    So a big iron cloud, with no Windows needed, and a competitor built on that model... what is MS's profit going to do under those circumstances?

    Or they can do a wee bit of work and satisfy both sides of this issue (there is an argument in here the OTHER way around, though it gets little interest as they are winning right now and not anticipating having to argue their side again). Stave off the liquidators a while longer.

    Or not. But it is not actually that hard to shift major programs. We've done it before, as a society, and we will do it again. Here? Maybe? If we have to. It's a pain, but not an unending one and makes room for a whole new generation to rise bringing new (old) ideas with them. So... whatever MS. IGNORE us. P*ss on us with mendacity (read ol' Johnny's message to us) and outright lies. See where it gets you.

    I will have a perfectly functional spreadsheet to use whether it is yours or Google's. To steal from NFL Films: "YOU make the call."

    An error occurred while saving the comment
    Roy commented  · 

    Yep, that's the one.

    In the Support article it implies/makes clear that if the entry does NOT exist, you have MDI. MAYBE that is the case in a version that has MDI for a default. Hoever, my Excel 16 has SDI as a default and I was strictly limited to File|Open or everything created a new instance. After creating the entry and giving it the value of zero, rather than no entry at all, I got some capabilities back, for instance, being able to drag a file from Explorer onto the instance of Excel and it would open in that instance where before creating the entry, it would open its own instance.

    So take the "no entry at all is the same thing" that they either say or imply with several grains of salt.

    An error occurred while saving the comment
    Roy commented  · 

    @Doug Reid:

    Sadly, it is no longer my most recent registry edit and it seems to have been deleted from here, a whole string of comments and comments back, 6-7-8 by different people. So I cannot say for sure.

    However, based upon memory, it was in a key in the Office structure and that key had a LOT of entries. In addition, it was a DWORD entry.

    So I will say it is the following key you want to add it to:

    Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options

    or whatever corresponds in your system. It has entries for Custom Margins through Monitor Topology Fingerprint through Use System Separators.

    The name to add is, I believe (not from memory this time, but because it seems to fit best and EVERY other one there is pretty clearly not it):

    DisableMergeInstance

    and the value to give it is zero ("0").

    (Because it is asking if you want to DISABLE merging instances which would disable all the MDI characteristics it will let you have. So 0 = False, as disbaling is NOT what you want to do, and should leave things enabled.)

    As I mentioned, it is not a return to MDI, and I went back and forth on it and deleted it too, hinking it had done nothing. Even thought it was a "ha ha" comment from a jack*ss until one of the comments had a Microsoft link for it (the real kind, one of their notes on how to work around their *****-ups, which, to be fair, though not happy, they DO come up with and offer while lots of others don't at all). Then I put it back in and suddenly caught on to the wording.

    The wording is like the way people write ballot initiatives, so a vote against turns out to be a vote for...

    Given the other stretch of comments is gone, I'm thinking this will only last so long and then be gone too. Stupid, really, given that I am less aggravated now I have this much, and one would expect others would be too, but... "beauro-think," aside from being the oxymoron of oxymorons, is a strange thing.

    An error occurred while saving the comment
    Roy commented  · 

    The registry modification DOES help out a bit. Now I can drag a file from Explorer onto the instance of Excel I have open and it will open in that instance where before the modification, it just wouldn't.

    However, that's aggravating to do. Clicking on the file in Explorer still launches a new instance of Excel. Don't get me wrong, I'm not undoing the modification but it isn't MDI.

    Further, I still can't drag an attachment onto the running instance of Excel and have it fire up. Won't open it at all. And every method of actually opening it opens a new instance of Excel. So... not MDI in the least.

    Lol, boy, they sure showed all of us "How could you not have a separate Undo stack for each file" people, didn't they? With SDI, it's completely not a problem...

    Lord, the way some people apparently think...

    An error occurred while saving the comment
    Roy commented  · 

    Yes, this is about "Unless I PURPOSELY choose an opening method that starts a new instance of Excel for opening some new file, I want every file I open in the same instance of Excel, NO MATTER HOW I DELIVER THE INSTRUCTION TO OPEN."

    So I open 50 spreadsheets? They are ALL in one instance of Excel. I might have used File|Open, I might have clicked on a desktop icon, I might have "Explored" for the file and clicked on it, I might be opening an attachment in an email: WHATEVER way I told it to open, it opens in that one instance of Excel.

    If that causes problems, they are my problems.

    Further, the idea this has to do with solving some issue with two monitors is either very particular to certain situations or I have, without the least effort or knowledge on my part, hit upon, utterly by chance, the better solution to it because for two years using 2013 I never experienced the issue. That reallllly suggests it is only in certain very particular situations, eh?

    And I can't even get the functionality by being careful in limiting how I open things. For example, I can "Explore" for a file and drag it onto the window for my single instance of Excel and I get the desired result though certainly not by just clicking on the file as I'd prefer. BUT... an attachment from Outlook simply WILL NOT open that way. I have no choice at all but to accept the second instance. So I cannot, through great care and effort even simulate the way it should work without effort. I imagine I shall find other instances in which this is the case.

    Further, we often have pairs of files we need to open here and for it to be done by users with no interest in learning the least thing about Excel. Until now, we could set up a couple icons, label one "Whatever-First" and the other "Whatever-Second" and they'd handle THAT flawlessly. Now that is going to open them in two different instances of Excel and quite fail to make one available to the other. Yay.

    And this back and forth business... New version of Excel? Oh yeah... it reverses the decision made on this in the last new version. So we have to go back and forth with this issue and when people have different versions... Spreadsheets are supposed to be quick-ish and simple-ish solutions to problems, especially ad hoc problems, not a new source of problems!

    They won't make simple, obvious changes to functions (like CHOOSE()... we ought to be able to give it a range and it would choose from the elements of the range... but it treats the range itself as an element... if we want to select from the cells in the range, we have to type each cell or its contents individually: i.e.: should be CHOOSE(3,A1:A4) returns A3's contents, but now we get an error and must use, say, CHOOSE(3,A1,A2,A3,A4) to get A3's contents) because, oh my, it could affect millions of users and their now "legacy" work. OK. Pretty valid, as a starting point. BUT... how is it something like this which is extraordinarily basic to usage can be changed willy-nilly with not just one sea change, like I mention for CHOOSE(), but with each new version hitting the streets??? Back and forth, back and forth.

    Of course, given the reponse to our desires and comments (as opposed to the useless and mendacious "attention" they get), maybe I should just be grateful the back and forth could have some very small component of responsiveness to the other side of this argument... Grateful to the gods that I got a crust of bread three weeks ago rather than railing at them for starving the three weeks since?

    That's not acceptable.

    And it wasn't really responsiveness to preference and utility that the other side claimed/claims anyway. It was that multiple monitor situation. Those folks railed for a long time, like we are now, and some still do because they still have versions that do what we like, and never really got a response. People with a "real problem" got a response, and the rest of us got slotted into a group called "whiners" and, you know, you can never content a whiner so why try at all, right?

    Well, since the last comment was meant to clarify so that some don't provide comment arguing for the opposite of the idea (Hope I haven't somehow misunderstood myself... could be I need to find a different suggestion to follow and support... by now I could be arguing against myself!) further clouding the issue though MS clearly understands each side of it and would be indulging in mendacity if they claimed we don't even know what we want.

    What I want is at the start of this comment: one instance with natural opening via all the ways Windows and Excel provide for opening files yielding them all open in the one instance and the ability via, among other possible ways, of forcing multiple instances by using Ctrl-Click on the Excel icon. Only intentionally opening a new instance would do so, not that being the default. (Hope I'm in the right place to support that... it'd be embarrassing as well as non-productive if I'm not...)

    An error occurred while saving the comment
    Roy commented  · 

    Good Lord. Some loser keeps putting posts in with the "F" word for two out of every three words (you've seen them by their dozens), and I put "S a t a n" (do I need to say "without the spaces?) in and THAT gets asterisked out???

    This place is ****. I live in a world filled with ****-a-holics. Find a 12 Step program and work it you clowns. Just... do NOT come around to me in whatever step that "make amends" step is. Just live with that blot on your soul.

    An error occurred while saving the comment
    Roy commented  · 

    Just how hard a concept is this? This has even more support than separate Undo stacks for each open file.

    And the opposite choice is just as supported.

    So... Jesus... OPTIONS... a simple setting in Options people, pick the one you want.

    Pick Always SDI and that's what you have. Pick Always MDI and that's what you have. Slight extra for the MDI folks: you can always CHOOSE to open a new instance of Excel and then open a file in it and so have SDI when desired.

    And then it's all over. Everyone is happy. Each gets his desire.

    My world was fine until IT overwrote my Excel 13 with Office 365 (32 bit even instead of 64 bit... who even thinks like that?). Now I am back to the evil world of SDI. Lived in that world four to two years ago, then lived in heaven, now today I'm back watching for ***** to come striding by.

    OPTIONS. Man o man people, just how hard is this?

    Roy supported this idea  · 
  10. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
    An error occurred while saving the comment
    Roy commented  · 

    I have bad news my friend... there is no actual encryption at all. There is information that the file is meant to be regarded as encrypted and Excel will honor that requiring passwords and not allowing access as appropriate, but no company in the world has to do this. Anyone at all can simply open the file and see any content.

    Only programs that simply honor the idea will not do so. It is all plain-text so... anything at all can read it, always. Some things just choose not to, to honor the idea.

    So it's a major thing as they'd have to actually implement real (like not decipherable by a simple macro) encryption of the file contents. No encryption, no actual protection.

    I myself use a macro from around 2002, freely available on the internet, that removes ALL internal protection and presents you two possibilities for the password the author used. That last is so that you may close and re-open the file, use one or the other password to relieve protections, do your work, then re-apply them as if they'd been in place always hoping to deceive someone about the fact you did things they wanted to prevent. For a moderate spreadsheet, three pages, it takes 2-3 seconds. (Pages matters more than number of cells in use for time.) The straw that broke my camel's back was a bank form that displayed (AND used) values in thousands (so "12" not "12,000") but had three mistakes with that which made the results wrong, and in my case, not in a way that was helpful! Just not having that.

    Sheets has NEVER honored Excel's protections, ever. I believe, personally, that is a passive-aggressive dig at MS. Gotta trash the competitor however you can, I guess.

    Very helpful if you ever want an unlocked view of an entire spreadsheet.

    By the way, Adobe's PDF format has the same issue. Nothing is actually done to a file, just a few settings changes, which any other program is welcome to simply ignore. Don't want to take a form from the IRS and keep the several pages of cr*p they include, just want the form? Use something not Adobe to open it and delete the pages of chaff. Save, then use normally. Slightly more complicated than that, for the program doing it, but that's it.

    Excel and PDF's are the two most prominent programs with this issue, but almost no one uses actual encryption at the equivalent of Excel's cell-level. Not even databases that advertise they do. Oh, and for Americans, there are no "4G" service towers in the US, no matter how many years you've heard of having 4G service. Curious to see if they are going to do the same with what will be called "5G"... all still 3G in truth. Liars. Scummy liars.

    Good luck man. Got my vote.

  11. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  12. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    它是所謂的“二進制算術”的人工產物。通常它出現在一個多位數的值的末尾,例如15.0000000000001,這就是這種情況,因為到達的值是:0.439999999999998,您會看到第15位出現錯誤。

    避免這種情況的秘訣是在計算結束時使用舍入步驟,以適合遇到的情況。畢竟,在源為四位數字的計算中,假設精度為15位數字是錯誤的,因此這樣做沒有理論上的困難,實際上,關於錯誤精度及其影響的標準思考需要這樣的東西。

    確切的捨入時間有時可能會很棘手。四捨五入後為時過早,同樣的事情發生了,所以它幾乎沒有完成任何事情。為時已晚,錯誤可能會傳播到其他內容中(不是像這樣,一次在一個單元中全部完成,而是如果這是一個中間結果,並且只在鏈中的最後一個單元中四捨五入,但是其他的分支鏈,它們都繞不過去,都使用相同的不准確單元...)。

    由於Excel內部使用26-27位數字,因此這很少會成為問題,但是發生的次數驚人地多。它本身不是Excel本身,而是1980年代初期制定的標準,一個足夠老的標準甚至在那時還是一個標準……而且,奇怪的是,似乎沒有人對MS感興趣,希望更新現代標準。

    (我使用Google翻譯創建了此評論,因此我很抱歉在文字或措詞中看到奇怪的地方。)

  13. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  14. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  15. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
    An error occurred while saving the comment
    Roy commented  · 

    I have bad news my friend... there is no actual encryption at all. There is information that the file is meant to be regarded as encrypted and Excel will honor that requiring passwords and not allowing access as appropriate, but no company in the world has to do this. Anyone at all can simply open the file and see any content.

    Only programs that simply honor the idea will not do so. It is all plain-text so... anything at all can read it, always. Some things just choose not to, to honor the idea.

    Still, D*MN sad Excel itself has a version that won't honor its own protections!

  16. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    Nope. Foolish idea.

    Also, their syntax is NOT in any way unintuitive:

    Lookup THIS in THIS TABLE and return the item in THIS column of it... not IN THE LEAST UNINTUITIVE.

    The TRUE/FALSE default is stupid, but not unintuitive. So... not unintuitive at all.

    Additionally, XLOOKUP() will not take mismatching ranges, so, for instance, using a column reference for one requires a column reference for the other. VLOOKUP() does not suffer in this way because it doesn't even arise. And MATCH() and INDEX() can have mismatched ranges without forced failure ("factual" failure might happen) so... perhaps XLOOKUP() is the function needing deprecation.

    Not that any of them do.

    A user with a level of skill to use INDIRECT() to allow row/column insertion to not upset his applecart could remove VLOOKUP()'s minor aggravation (column insertion) easily.

    "Looking left"? Not so easily. But seriously, most uses do not end up in that particular applecart.

    Most INDEX/MATCH folks, I am absolutely sure, used it in both kinds of uses simply because they only desired ONE way of doing things (when doing so worked fine) so they used it even when unnecessary, not from VLOOKUP() being horrible, but rather to just do it one way.

    I wager VLOOKUP will slowly fade into a retirement home in Florida all on its own. It needs no help and why aggravate people who use it routinely.

    For their own good? Pretentious b*st*rds often think like that. I hope that is not the case here. It would remove any referential authority one might assign to your opinion.

  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    Um... so you can send a billions messages in one fell swoop?

    Honestly, that sounds like the killer chainsaw guy asking me to oil and sharpen his chains... then lock the door and board up the windows.

    I can't really get behind anything making that easier, even if YOU are not the evil fellow looking to plague me with a million messages that were no effort at all for you to do... because someone else will very willingly fill that role.

  18. 264 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    You can ALMOST do the AutoComplete thing. But the way I'm thinking of isn't "live"... one has to enter the characters, then press Enter, then the dropdown box has an appropriate list. And rinse and repeat to narrow it down further.

    Sure doesn't help with the eight items part though.

    Roy supported this idea  · 
  19. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Roy commented  · 

    I agree the first press of Enter to save the entry will change it to "=ELSE" but pressing F2 to edit and changing it back, then pressing Enter to save the edit lets it stand.

Feedback and Knowledge Base