Feedback by UserVoice

Kenneth Barber

My feedback

  1. 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 shared this idea  · 
  2. 27 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  · 
  3. 51 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  · 
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber shared 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

    Kenneth Barber commented  · 

    There seems to be some ambiguity on the definition of ACSC and ASEC:
    https://en.wikipedia.org/wiki/Inverse_trigonometric_functions

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Why not just instead use the Power Pivot window's measure grid to write your measures?

  8. 121 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  · 
  9. 294 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  · 
  10. 23 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  · 
  11. 20 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

  12. 58 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.

  13. 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.

  14. 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.

  15. 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

  16. 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.

  17. 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

  18. 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  · 
  19. 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

  20. 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.

Feedback and Knowledge Base