Feedback by UserVoice

Kenneth Barber

My feedback

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I use OLAP PivotTable Extensions to disable the automatic refresh:
    https://olappivottableextensions.github.io/Disable-Auto-Refresh.html

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I see this being most useful for being able to create a Date Table using CALENDAR or CALENDARAUTO, or some other table that is based on multiple tables. Power Query can be a bit slow in creating tables that are based on multiple other Power Query tables.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    There's already a HYPERLINK function in Excel. I guess we would need this in DAX as well.

  5. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Instead of importing your data directly into Power Pivot and then adding a calculated column, import your data into Power Query (Get & Transform) and add your new column there. You can even exclude columns if you want. Then load the Power Query table to the Data Model.

    To keep things organized, it is usually a good idea to restrict the Date Table to contain date-related columns only (date, year, quarter, month, month number, day, etc.) and then use a relationship to link it to your data tables. I doubt that the table that you are importing into Power Pivot contains only date-related columns.

  6. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    You could also add a PivotTable and not place any fields in it yet, and copy and paste that.

    Kenneth Barber commented  · 

    You're onto something. What if you had a single PivotTable with a bunch of saved configurations? Then instead of having multiple PivotTables, you just switch the one and only. 1 raw data table, 1 summary table (PivotTable).

    I made a suggestion based off of yours:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10886520-saving-pivottable-configurations

  7. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    It sounds like part of the solution is to name your fields a bit better. Also, what is the difference between clicking the pop-up that you are suggesting versus clicking on the source data sheet other than the negligible difference in distance from the PivotTable fields? The fact that you need to readjust mentally after the pop-up appears and shifts the PivotTable Fields pane to the left negates any time savings.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Solution:
    File → Options → Data → Disable automatic grouping of Date/Time columns in PivotTables

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Right now, the only way to do this is to use the CONCATENATEX function in Power Pivot. It would be nice to not be forced to resort to this.

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    This has already been addressed in later versions of Excel.
    File → Options → Data → Disable automatic grouping of Date/Time columns in PivotTables

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    On the Insert tab, there's a Table button. Use it to put your data into a table, and then base your PivotTable on that table. Tables given default names for columns with no name.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  14. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  15. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    In your case, you should retrieve the data using Power Query (Get & Transform). In Power Query, you can specify what data you do or don't want. Then load the Power Query table into the Data Model.

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

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    This should be moved to the Excel for Mac section:
    https://excel.uservoice.com/forums/304933-excel-for-mac

  17. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    You seem to be suggesting the ability to invert the filter selection for PivotTables. I've linked the equivalent suggestion for tables below:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/19392202-invert-filter-selection

  18. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Excel has all of this now, minus some DAX functions.

← Previous 1 3 4 5 42 43

Feedback and Knowledge Base