Feedback by UserVoice

Anonymous

My feedback

  1. 874 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  · 

    I don't see how the Excel feature of "tables" (structure references, filters, auto-expand, etc) working with an Excel feature that predates them : the ability to protect sheets, would harm Access.

    Tables working would not make Excel a database management system... and tables not working is not preventing some people from using Excel as if it was a DBMS. (anyway this isn't about Access or even about the MS product marketing strategy, this is about the Excel product responding to it's users needs)

    Tables make Excel formulas easier to read, maintain and audit. Reducing the risk of having a "bad" Excel sheet giving bad information and leading to catastrophic decisions.

    The Excel team made a choice of adding tables to Excel (great choice) and put efforts in developing the tables and structured reference... but they left it unfinished. It works in it's own bubble but not with the parts of Excel that existed before and are key aspects of Excel like the ability to protect a sheet. Before tables, when you had a "data table" on your sheet you could protect the sheet and select to allow rows to be added (among other things)... the use case was supported...
    then they give us all those great tools to develop better tables... you spend time learning and creating something great...
    then you protect the sheet before sending it out, you select the option to allow adding rows (since the dataset keeps growing)... and you realize it doesn't work...
    you do an internet search thinking you forgot something... and then it dawns on you that you lost all that time because you can't use your brand new shiny table in the real world because it doesn't work!
    The use case didn't change, they just stopped midway when implementing their new tables!
    (... and then you realize the wonderful structured references won't work in conditional formatting or data validation! and those are probably the formulas where it would be the most useful [I don't know about you, but some of my most complex formulas are in the conditional formatting... where I can't "see" the names of the columns/cells I have to reference]...but that's another thread)

    There's no real Excel evolution because we can't move on to fully adopting and using tables (and other "new features"), because we keep having to go back to the old way of formatting "tables of data" (so we can protect them), of defining ranges and writing formulas...

    Excel is great, Excel can feel easy to use... but Excel is also great at making it easy to create good looking spreadsheet that give bad information and can cause a lot of damage to an organization. A lot of people using Excel don't understand it enough to be careful and to know all the pitfalls (and there are many), protecting a sheet gives us a chance of having a reliable spreadsheet so it can give reliable information. The Excel team used to understand that : they gave use the ability to protect sheets. But now they seem to have forgotten that basic fact. Sheet protection doesn't work with tables or with data refresh (another thread). It might look good to add "new" features, but if they don't work with what was there before, if they stop supporting the use cases that brought us to Excel, they should be in their own program. If you don't want to make it work with the "old" Excel, then don't try to past it off as Excel...

    Anonymous commented  · 

    This really is a bug and a major one, no voting should be necessary.

    This needs to be fixed!

    Protecting the structure of a sheet from end users with limited knowledge of Excel is a basic need because the people constructing the sheets and analyzing the data are often not the same people that enter the data day to day. A protected sheet helps both with data integrity and with facilitating data entry.

    Tables and structured reference are powerful tools but they just aren't an option when they stop working once you protect a sheet!

    (I was so frustrated when I discovered that bug after weeks perfecting a workbook for distribution to data entry people! I couldn't believe it! I finally had to revert to "classic ranges"... what a nightmare that was!)

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

    We’ll send you updates on this idea

  3. 305 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous commented  · 

    This sounds great!

    I must admit facing the Formula.Firewall problems get frustrating when you can't set it to Ignore but most of the problem queries are fetching data (mainly parameters) inside the same workbook where the query is located!

    Query in query works most of the time but it gets hard to read sometimes and there's one query type I haven't been able to make work yet,without ignoring security, when using parameters...

  4. 694 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    Anonymous commented  · 

    @4am : In fact, I think the first time I realized I couldn't use a named range in the "Applies to:" field, I was hoping setting a table column as a named range and applying a conditional formatting rule to that range would allow to paste/remove a row in the middle of the table without having the conditional formatting rules go wild!
    :-(

    Anonymous commented  · 

    This really should have been implemented years ago!
    It feels like some great additions to Excel that should make it easier to work with were not completely implemented and now make things messy and hard to work with.
    Named ranges, and even more so Tables and structured references, would be so great in making complex sheets easier to read and audit. Making them reliable...
    BUT you can't really use them consistently because they don't work with some parts of Excel... it's not like we're talking about different programs here! It should be an evolution... but by being incomplete it keeps causing trouble and we can't move on!
    I ended up here because I was looking for a work around for a bug with a "newer" part of Excel : Power Query
    When refreshing a table created from a query... the conditional formatting gets all messy (like it would if you added/removed rows in the middle of a table)... I was hoping to use a named range (set to the table, like you have to do to use in a formula for a conditional formatting rule) before I remembered you can't use named ranges in the "applies to" field...
    This is so frustrating!
    Excel keeps adding "new" features... but they don't work with what was there before! There’s no compatibility INSIDE Excel itself!!! Allowing conditional formatting to be applied to named ranges would allow for many work around so we could use many parts of Excel together...
    Please give new feedback!
    This issue has been addressed in different suggestions splitting the votes, but it still has quite a number of votes! And please think of the usability of Excel as a whole, many many people who haven't found their way to this suggestion would find their use of Excel simplified and less frustrating with this ability.
    New features might be nice marketing, but if you can't use them together with the other parts of the program, you're only failing to meet the expectations you set and eroding the trust in your next promised feature ("Great, something ELSE that won't quite work!")

    Anonymous supported this idea  · 
  5. 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  · 
    Anonymous commented  · 

    I think it would be great if there was a function returning the background color of a cell so the result could be used in other formulas (in a simple if or a countif)

    But for now, if you want to count the number of non empty cells in a column with ONE background color, you can achieve this by using a table with a total row count [subtotal(103, column )] filtered by color.

  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. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 
  8. 16 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  · 
  9. 129 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

    Anonymous supported this idea  · 
  10. 5 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  · 
  11. 5 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  · 
  12. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous commented  · 

    At least some locales already have this (it's the default format for me)
    It often called ISO 8601

    but if it's really not one of the date formats you have access to, you can define a personalized/custom format

  13. 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  · 
  14. 46 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  · 
  15. 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  · 
  16. 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  · 
  17. 23 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. 16 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  · 
  19. 294 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  · 
  20. 51 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  · 
← Previous 1

Feedback and Knowledge Base