Feedback by UserVoice

Malcolm

My feedback

  1. 34 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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.

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

    We’ll send you updates on this idea

    Malcolm shared 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

    Malcolm shared this idea  · 
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  5. 386 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! 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.

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

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    An error occurred while saving the comment
    Malcolm commented  · 

    Over two years and we still don't have this. It's still back in the dark ages for this where you could only run one program at a time. Screenshots or handwritten notes really should not be needed in this day and age but it is the only way of seeing the data file and the query at the same time!

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

    I agree: it slows down work considerably having to keep quitting the query to check the underlying data.

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

    We’ll send you updates on this idea

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

    An error occurred while saving the comment
    Malcolm commented  · 

    It should interface properly with Power Pivot which does have a null type, please.

    Malcolm supported this idea  · 
  9. 989 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    An error occurred while saving the comment
    Malcolm commented  · 

    I'm also finding that the most common reason Excel crashes and needs to repair a file is to do with conditional formats in tables. When "repaired" the conditional formats have been stripped out entirely. It only occurs in tables when there is a formula used to select the conditional format but it occurs so regularly for me that I now have macros in my spreadsheets that detect if a conditional format has "disappeared" and re-instates it!

    When looking at dealing with the named ranged issue, please can you also look to remove whatever bug causes these table-based conditional formats to crash Excel?

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

    We’ll send you updates on this idea

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

    As the person who you say "describes the mechanism best" I will definitely vote for this and thanks for summarising it all. The approach to headers and footers, even its appearance, shows that it has really not been thought about since the days Excel was first launched.

    It's something people have been asking to be approved for years and yet instead we get glossy new charts, "ideas" and such like which must be far more difficult to program and less useful to the wider audience.

    Come on Microsoft, bring headers and footers in to the late 20th century at least.

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

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Malcolm shared this idea  · 
  12. 78 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
    Malcolm commented  · 

    Couldn't agree more. It has been a real productivity waster for years, having to reset the panes every time.

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

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  14. 1,513 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

    An error occurred while saving the comment
    Malcolm commented  · 

    Given that Power Pivot is becoming an ever more promoted part of Excel and Power Pivots and queries often depend in user input tables, it is absolutely mind-boggling surprising that this gross oversight has not been fixed.

    An error occurred while saving the comment
    Malcolm commented  · 

    Getting even more important now that Bi and get & transform are becoming an everyday tool. We critically need to be able to protect the cells around these tables whilst allowing rows and columns (don't forget pivot tables) to be added and deleted.

    Malcolm supported this idea  · 
  15. 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
    Malcolm commented  · 

    It has been suggested for a long time now that Excel introduces Regular Expressions into search and replace. This would solve the issue at a stroke as well as allowing for more flexibility throughout. It's all there in VBA already, how hard would it be to implement in the Search and Replace box?

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

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  17. 613 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 the support and comments about this request. We don’t have plans to add this format in the near future, but we’ll keep monitoring the votes as we prioritize this suggestion among other requests.

    There are a few ways that you can enable this already, as mentioned in some of the comments.

    1. Set the style used when you click the comma button.
    – This can be done by modifying the cell style called “Comma”, which is used when you click the comma button. See the screen shot in the comments for details, or look at this article to modify the style – https://support.microsoft.com/office/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22.
    – For existing workbooks, you’d need to set the style in each workbook.
    – To make it the default in new workbooks, you can create a new workbook, make the change to the “Comma” style, and then save the workbook as a template…

    Malcolm supported this idea  · 
  18. 68 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    I have great news to share. We are planning to make the Conditional Formatting Rules Manager and rules dialogs resizable. Thanks for all the votes and comments for this suggestion.

    We’ll provide more updates here as we get closer to releasing the update.

    Steve [Microsoft Excel]

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

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base