Feedback by UserVoice

Malcolm

My feedback

  1. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  2. 57 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Malcolm commented  · 

    I don't think we are going to get them. It's been 6 years since my request and since then we have had a whole load of complex things added whilst what would seem to be simple things aren't done.
    :-( Look how long it took to get "Unhide All" for worksheets.
    Here's hoping though.

    Malcolm supported this idea  · 
  3. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  4. 13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Malcolm commented  · 

    I've made a separate recommendation about getting INDIRECT to work with DataTypes. Basically any reference that you can put in a cell which works in that cell should be able to be turned into text and wrapped in INDIRECT(() and it should still work

    Malcolm supported this idea  · 
  5. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Malcolm commented  · 

    Use Power PIvot instead?

  6. 291 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  7. 12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Malcolm commented  · 

    Maybe there should be an option to hide it. I have multiple accounts for different businesses and having my name (or at least the little picture) there has saved my bacon more than once. I would NOT like it to be removed entirely.

    If more space is needed at the top (and I would like to see the path as well as the file name) then I would happily lose the Search box. I've never used it and, if needed, it could go on the ribbon itself next to Share and Comments.

  8. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Malcolm commented  · 

    It needs a better re-think than this. The 'Refer To' should effectively be like the standard formula entry field for a spreadsheet which has an fx button, will parse the formula on entry, etc.

  9. 135 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  10. 115 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  11. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  12. 80 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  13. 46 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  14. 128 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Malcolm commented  · 

    The whole process of adding LAMBDA functions into name manager without any checking is madness. LAMBDA functions should be able to be typed into something with all the checking and editing facilities of the formula bar.

    It surely should be possible to repurpose most of the current formula bar code allowing the entry of a LAMBDA function into something similar to a cell and providing exactly the same experience of entering a formula into a cell?

    When editing a formula which contains a LAMBDA function there should be a one-click method of getting to the LAMBDA function editor.

  15. 34 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    If we break the link to the data, the PivotTable will no longer be interactive and won’t support expand/collapse, filtering, or sorting. Copy/Paste into Paint or any other graphics program will preserve an exact picture of the PivotTable with all formatting. In any event, this item isn’t likely to be addressed soon.

    An error occurred while saving the comment
    Malcolm commented  · 

    The best work around at present is to use Power Query rather than a Pivot Table, then you can delete the query and the table stays with all the formatting you have used.

    If there are specific features of a pivot table you need which are not available easily in Power Query then create a Power Query that dumps an intermediate summary of anonymised data into another table (which you are prepared to give to the third party) and use that as the basis of the power pivot.

    Neither are ideal or as elegant as simply de-linking a pivot table though. Hopefully Microsoft will reconsider this thought. It would be so much more useful (to me at least) than some of the features which they have added and which must surely involve a lot more coding effort for them than this.

    An error occurred while saving the comment
    Malcolm commented  · 

    Not really an answer. One would not expect it to be interactive. That is the point of breaking the link. If the breaking of the pivot table turned it into a table it would still support expand/collapse, filtering and sorting.

    We don;t want a picture as that will definitely not allow expand/collapse. filtering and sorting and will break any links out from the pivot table (should there be any) not only those in. Using a picture also involves a fundamental change to the spreadsheet rather than a simple breaking of a link.

    It's rather like requiring people to take pictures of worksheets in a workbook in order to send the workbook to somebody else rather than merely breaking the links in the workbook. That would clearly not be sensible and nor is the work around proposed.

    Please reconsider.

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

    Please, please sort this. Every week I need to send the results of a number of pivot tables to a third party without any references to the source data. At present I have to copy the values to a new file, which breaks all the formatting and then go through and recreate all the formatting manually. Even though I am using conditional formatting and vba to help in this task, what should be any easy thing to do takes ages.

  16. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  17. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  18. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  19. 393 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

    Best,
    John [MS XL]

    An error occurred while saving the comment
    Malcolm commented  · 

    XLOOKUP is good. Thanks for that.

  20. 656 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Malcolm commented  · 

    Still waiting for this after two years and wondering why it is so difficult to implement. We've got Regex in VBA after all, so most of the parsing code must be there and ready to re-use.

    We've had a lot of other changes to Excel in those two years - many of which don't appear to have been requested by users (at least judging by this forum) but we are still awaiting some of the more requested ones here!

    Malcolm supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base