Feedback by UserVoice

Anonymous

My feedback

  1. 829 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    Anonymous supported this idea  · 
    Anonymous commented  · 

    HACK TO COPY BETWEEN INSTANCES AND RETAIN FORMULAS: Find and Replace the "=" with something that appears no where in your workbook eg one of the alt + num pad hard characters. I usually use one of the Greek characters Alt+num pad 234 Ω. Copy paste your sheet or range. Find and replace the Greek character with "=".

    Anonymous commented  · 

    Please fix this. I managed to kill a worksheet recently because undo is not by document vs global. I knew that this was a glitch in Excel...too many things going at the same time a mistake was bound to happen, but it should not be this way!
    Really, you have us trained to undo by document in Word and Powerpoint, how difficult was it to do the same in Excel? I would much rather lose the functionality of having 2 documents in separate windows and still have undo work correctly.

    Anonymous commented  · 

    Keeping formulas when copy/pasting between 2 instances:
    I've used Excel 2010 until recently. I used the following to work around the conversion of formulas to values when I had more than one instance open.
    Find and replace = with µ (Alt+230 on the num pad)
    Copy paste the values
    Find and replace µ with =
    I don't usually have links to other sheets to deal with so you should check those.
    If you also want the formatting, paste it separately.

  2. 1,566 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous commented  · 

    For any sheet where I may have variations of sort and then have to unsort back to the original, I insert a column on the left hand side (it can go anywhere, it's just easier in column A). Enter '001 in the first cell Autofill down to the last row.
    Notes:
    * If there is a header row I start numbers on A2 and name the column "Sort"
    * The apostrophe+leading zeros makes sure that the sort is truly numerical.
    * The number of leading zeroes depends on the expected number of rows in the sheet (eg '0001 '00001 etc).
    * Resorting to original can be done with the A-Z arrow sort instead of setting fields
    * Make sure that all the columns are selected when doing this

  4. 6 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous 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

    Anonymous commented  · 

    Unfortunately this is deliberate. Please add this comment to one of the "Make undo work the same way as previous versions."

  6. 2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  7. 26 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  8. 4 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous commented  · 

    I didn't mean to vote... I never use the icons to save and undo so don't understand why it's a problem, Ctrl+Z for undo and Alt+F, S work well.

    Anonymous supported this idea  · 
  9. 21 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 feature suggestion. We’ll definitely consider changing this default. Please continue to vote on this feature idea which will increase its chance of getting in the product.

    Thanks,
    Scott [MSFT]

    Anonymous supported this idea  · 
    Anonymous commented  · 

    I agree wholeheartedly. We have graduate students who paste from excel into word or powerpoint on a regular basis. Most are experts at running the numbers but have less experience with other features. They are often on tight submission schedules and I get panicked calls when the quality of the pasted image is blurry. It would be awesome if the default was of good quality.

  10. 46 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous commented  · 

    John, This is the same problem as "Allow us to turn off automatic conversion to date", please combine

  11. 129 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 suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    Anonymous supported this idea  · 
  12. 284 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 suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!

    Cheers,
    John [MS XL]

    Anonymous supported this idea  · 
  13. 94 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  14. 307 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 who commented on this topic. This is certainly an idea that we’ll consider, but in the meantime, I wanted to mention that if you can’t see all the sheet tabs, you can right-click on the navigation arrows to bring up the “Activate” dialog, which gives a scrollable list of the sheets, so you can select the one you want and navigate to it. I know it’s not exactly what’s being suggested.

    As with other ideas, we’ll look to see how many people vote on this, so vote for it if this is an area you want to see improved.

    Thanks,
    Steve (MS Excel)

    Anonymous supported this idea  · 
  15. 97 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 feedback. This is a known issue which we have concrete plans to fix. However, please continue to vote on this issue.

    Thanks,
    Scott [MSFT]

    Anonymous supported this idea  · 
  16. 89 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    This is an interesting idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Anonymous supported this idea  · 
  17. 124 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  18. 181 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 post Charles, and for the in person conversation at the latest MVP conference. We definitely understand the ask and will keep our eye on it – it looks like it’s moving up the vote charts pretty quickly. As always, keep upvoting the things you are about most.

    Best,
    John [MS XL]

    Anonymous commented  · 

    Oh my, I think I've just found out why my spreadsheets sometimes run so slow. Auto calc in active workbook makes sense to me. Auto calc in all open workbooks? It is a no-brainer and needs to be fixed.

    Anonymous supported this idea  · 
  19. 975 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

    John, Excel

    Anonymous commented  · 

    Completely agree with Alan Odom comment. In addition to his comments:
    1. I don't want Autosave so I lose my backup facility
    2. Undo - why in heaven's name would anyone at Microsoft think it is a good idea to undo in a single stack for multiple documents? It doesn't work this way in any other program and for anyone who works on multiple projects and has to turn on a dime to open a different workbook and answer a question, it's dangerous. I know it does this and yet I still lost a bear of an analysis by saving without realizing it.
    3. The ribbon interface in Excel 2016 is harder to read and cannot be modified for color, or icon size. Having that plus different iterations of it for each workbook...if I could use Excel 2010 I'd be happy, if I can at least use Excel 2013 that would be good, but the push to 365 has hit our university.

    my workbooks take forever to open and also to save in 2016. Today after waiting over a minute I went to my computer with Excel 2013, opened Excel, and opened the workbook. It was still hanging in 2016 - took another 15 secs to come in.

    Anonymous supported this idea  · 
  20. 815 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Anonymous commented  · 

    This would be a very useful feature. At present if I need to add an additional row just to add some space let alone additional data analysis into the protected formula section, I unprotecting and reprotecting for each worksheet. This is fine, if we are close to the beginning of a project. Once I have >50 it's painful. In fact, is there any chance of allowing a power editing password? Something that would allow me to release the protection for the workbook to tweak a given formula without doing so for each sheet individually.

    Anonymous supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base