Feedback by UserVoice

Tom

My feedback

  1. 120 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
    Tom commented  · 

    For simple situations I have just used =iferror( FORMULA /1,"") and to get rid of the pesty "1/0/1900" for formulas related to dates with 0 as the result my son came up with =iferror(1/ FORMULA ^-1,"") which works great.
    BUT, we need this idea as something simpler to use. "I vote YES!"

  2. 934 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
    Tom commented  · 

    Yes, PLEASEEE

  3. 13 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
    Tom commented  · 

    *Can you give an example of when you would want PivotTables to be reference-able through named ranges*
    I have a data source from an accounting program which is accessed through Power Pivot. I have created Power Pivot reports that have created the data I want. I have monthly reporting that requires a specific format for hundreds of charts and graphs.Currently, I manually create named ranges in these pivot tables to create standard tables that I can then use to create my reports, charts, graphs, etc. This works fantastically but takes a bit of work to set up. I also have another need to combine additional data into some Pivot Table data on the fly so I have created a table from the original Pivot table data, added to it, created formula's, and a new pivot table created from this enhanced Table.

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

    I currently manually create named ranges for Pivot tables and it's great. it needs to be an automatic feature. Pivot tables have a bad rep for poor formatting (rightfully) and you are stuck with the derived values on the right. Plus if you want to use this data as a source for part of a more complex table or any other purpose it's not very easy. Don't even start with GETPIVOTDATA (it has it's uses but...) Creating names ranges opens up a huge capability but it's a pain to create in the Name Manager as you can't copy the ENTIRE named range and then simply change the name and the necessary tweak for the next column. This would finally get people to use pivot tables like they should.

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

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Tom commented  · 

    Yes please. That would save a bunch of manual work

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

    We’ll send you updates on this idea

    39 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Tom supported this idea  · 
  6. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Tom commented  · 

    see also "Allow Pivot Tables to be referenced via named range similar to Excel Tables" in this Suggestion area.

    Tom supported this idea  · 
  7. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Oh yes PLEASE! PLEASE! PLEASE!

Feedback and Knowledge Base