Feedback by UserVoice

SEUMAS MACLAREN

My feedback

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

    We’ll send you updates on this idea

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    I think most agree it is not complex to provide basic separation of undo between workbooks. Appreciate the need for special cross-workbook advanced undo - so make it an option to turn on? Of course there are users with complex requirements for workbooks, and, if that functionality works now, then it seems to me that we should have a switch available for users to enable cross-workbooks undo to integrate undo stacks after a restart of Excel perhaps. Otherwise the default should be a simple segregated set of undo stacks; one per instance, with a maximum undo level of say, 500 changes. No one will argue with that. Even 100 would be fine and most will only ever use 50 or so. We don't need to reinvent wheels.
    The general argument I would propose is: The specialist needs of a few users should not make the feature unusable to all basic users who want to open a couple of unrelated sheets during a phone call, and make a few edits, but undo some of those later. Undo MUST (by the rules of WYSIWYG) undo at the visible point one selects the undo action, else warn you about the changes. It's such a basic functionality to communicate with the user. Undo should also perhaps have an option, rather like the Review functionality on a Word document, not show, or register some format changes like zooming a sheet (as already requested by others) or changing text format
    perhaps (although Track Changes does work a bit different from undo in Excel admittedly).

    Please consider providing user interface communication with the user using an edit-Undo dashboard that can float, or pop-up. At present, the user does not even have the option to see the undo-action list with the references to the worksheet and select the action required. It should (or could) flag the workbook name at the heading of each set of undo actions, all the way down that drop-down list.
    Make any sense? -Hope so.
    Cheers all for such a brilliant and strongly focussed campaign to get Microsoft Excel chiefs listening.
    SM

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    We need a Workbook-based undo buffer, as we have said, WITH the ability to purge the undo buffer manually, or on a manual save (just like the Accept All Changes and Stop Tracking removes all previous change memory items in Word).

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

    Is there anything new about this issue which was first raised over 6 years ago on other threads? This is a HUGE productivity issue and MUST be prevented from any further drift NOW please. This is a QUALITY issue and relates directly to being able to track version control in Excel - enabling quality controls within a task or a design. We simply have to get it changed. Please. Please STOP adding minor usability innovations like auto-save and concentrate on what matters to power users who pay a lot of money monthly for upgrades that we have no control over. We need proper engineering to address this most fundamental issue. Not bells and whistles.
    Most power-users work within multiple workbooks, just as they do with Word, or other apps. Why is Excel deficient: I shall tell you why: There is a lack of standardization and so lack of common architecture for Office applications and things have been allowed to drift at Microsoft. Get it sorted please.
    Many thanks.

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    Thanks a lot John and Team. Have a great Easter break. :)

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    Further to comments by Anon. on 26th March: Re. "Right click on the Excel Tab in Windows taskbar keeping the ALT key pressed" -This option is not available in Windows 10 with Excel 2016. However, the Excel /X option works and a second change-undo buffer is created in the new process. A good work-around. Suggest the Office Excel menu shortcuts put the /X option into the application shortcut set, and/or put a File | New Excel process option on the apps own menu. Transparency of options. But that does not take away from the need for a unique undo per document context.

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    For goodness sake stop this nonsense of collecting votes and fix this fault. This is an anomaly that NO OTHER Office application would tolerate. PLEASE.

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    Please note that merely saving the workbook using Excel 2016 / Office 365 ProPlus does not remove the change record buffer on save. Perhaps older versions removed changes?

    But it still merges all changes to one change buffer across all workbooks open, which is the major flaw. Microsoft Word does not do this. Hoping for a correction to this soon. Split the buffer please to each workbook having its own.

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    This Undo issue is a bug and the height of lazy design. No two ways about it. It is one of the MOST inconvenient, non-standard, deviant and lazy things that Excel has just left in there, version after version, despite the fact that many users of so called Office Professional editions and above routinely use mutiple spread sheets and cannot seriously be expected to use an undo buffer that undos (to the user) randomly, across different workbooks!
    Unless one in not changing more than one workbook, this is a useless function. The workbook one is correcting requires an undo every so often, not the one being referred to, where only zoom levels are being used. (And please please can we NOT store zoom levels as document changes to undo? This is just silly. Other competitor products have full separation and, by the way, so does Word.
    PLEASE harmonize the technology better across Office applications: UNDO, SEARCH and allow colours to default to Window default settings when using Classic desktop scheme.

  2. 50 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
    SEUMAS MACLAREN commented  · 

    Why do some of the most useful features of the most basic operational use in Excel get pulled out, when it is clear that individual settings and tuning on a personal basis is what people want?

    An error occurred while saving the comment
    SEUMAS MACLAREN commented  · 

    Agreed. I am using Office365 Pro version and the option is not there. It has been driving me crazy today since I need to scroll a Word doc rapidly, whilst reviewing/editing an Excel sheet. BUT previous versions I am sure have had it, and I have changed to scroll one line (necessary when cells are very large and occupy 1/2 the display each, whilst keeping my mouse default to 2 or 3 lines for use in scrolling in Word etc.
    WHAT the heck happened to the settings in Excel options menu? PLEASE put this back in.

    SEUMAS MACLAREN supported this idea  · 
  3. 1,280 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. …

    SEUMAS MACLAREN supported this idea  · 
  4. 13 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
    SEUMAS MACLAREN commented  · 

    AGREED. There is no proper usability reason for removing the sheet highlight when the Excel application window instance is not in the foreground. Why is this the case? For example, I often require to look at a complex sheet when writing a Word report on the data, or compare sheets, and need to keep my sheet highlighted to see what I am checking whilst working on the other document. This now ubiquitous behaviour in Windows has no user-friendly reason and should be, MUST be removed for common sense. All experienced users, will I am sure agree. It is only beginners who lose the sense of what is actually in the foreground.

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

    We’ll send you updates on this idea

    SEUMAS MACLAREN supported this idea  · 
  6. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    SEUMAS MACLAREN supported this idea  · 
  7. 9 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
    SEUMAS MACLAREN commented  · 

    Cursor visibility is a serious and annoying problem that would be relatively easily corrected, and made user controllable. It has come up in many different posts. Agreed this is a problem.

    SEUMAS MACLAREN supported this idea  · 
  8. 3 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
    SEUMAS MACLAREN commented  · 

    The problem is that the cursor has to start somewhere - the application cannot anticipate whether the user will change the 'Find what' or the 'Replace with' string.
    Notice that after using find/replace, and then re-opening using Control+F (Find) this is the position of the cursor. The 'Replace with' string also remains until changed. So - if you know you need to search again for something else, just use Cntrl+F. Problem solved? Otherwise, learn to use the voice commands which are now very powerful.

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

    We’ll send you updates on this idea

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

    I think this has come up on multiple issues/requests, one of which was posted by me relating to the fact that the cursor cannot be seen for several seconds in a large sheet against the background colour selected, or even when there is no background!
    1. It is just NOT bold enough (and does not contrast automatically (should automatically contrast intelligently with the background, as used to be the case with Lotus 123).
    2. A green cursor is a problem for colour blindness. Did Microsoft design team not think about that when dictating the banal, useless restrictions on colour scheme?

    WE HAVE NEVER had a proper answer as to what on Earth they were doing when restricting the ability to use the Windows OS colours. (Lunacy and gross arrogance towards the user). I am slightly colour blind and often find myself unable to find cursor position. There is, as far as I know, no default way to control the cursor colour, and this should be available. GET IT RIGHT please? We are no all little green Martians!

  10. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    SEUMAS MACLAREN supported this idea  · 
  11. 109 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    SEUMAS MACLAREN supported this idea  · 

Feedback and Knowledge Base