Feedback by UserVoice

Andreas Thehos

My feedback

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

    We’ll send you updates on this idea

    Andreas Thehos supported this idea  · 
  2. 3,640 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    812 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for supporting this suggestion with your votes. It’s unlikely that we’ll be able to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS. We’ll keep tracking votes, since we know that the scenarios made possible by PowerPivot are important, even if the solution will need to be something else.

    Andreas Thehos supported this idea  · 
  3. 1,208 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    323 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

    I updated the title and description for this one and we’ll continue to monitor for comments and votes.

    Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality

    Steve K [MS Excel]

    Andreas Thehos supported this idea  · 
  4. 3 votes
    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 Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Andreas Thehos supported this idea  · 
  5. 99 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    This is an interesting idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

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

    That would be great. Actually we are using several VBA Solutions to create presentations automatically.

    - f.e. save one presentation for any row of a large Excel PivotTable by pressing a button. This saves days at creating nearly 800 different presentations.
    - to fill several objects of different slides by connecting cell references to slides and form names (Some VBA Code at YouTube (German) : https://youtu.be/K3zvMrrYaHM )
    - for mass printing of different Excel rows to the same type of slide (certificates like mail merge in Word)

    The implemented solution could be a simple list of cell and object references to the path of a PowerPoint template, the slide number or type of slide and the name of the destinatíon form.

    Thanks again
    Andreas

  6. 1,426 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
    Andreas Thehos commented  · 

    This would be a really helpful change.
    We use to protect Sheets, but it would be great, if you could add new rows at the end of a table by using tab. So you would protect the shape (maybe the formulas, too) of a table, but could select:
    - edit all rows
    - just add new rows
    - edit or protect formulas

    Thanks
    Andreas

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

    We’ll send you updates on this idea

    We’ve just merged two items that were both requests for the Median function in PivotTables. One had been for Windows, the other for Mac. When we get to this, we should actually make the addition on all platforms including Windows, Mac, Web, and others.

    An error occurred while saving the comment
    Andreas Thehos commented  · 

    Hi, you have to calculated Median beside your PivotTable. You can see a workaround on this German page: http://thehosblog.com/2013/08/02/excel-median-fur-pivot-tabellen/

    WENN = IF
    AGGREGAT = AGGREGATE

    Or use Mourad Louhas Excel-translater.de ;-)
    Good luck
    Andreas

  8. 20 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
    Andreas Thehos commented  · 

    Use allways the function ROUND to fix it. I'm looking at this problem for the last years and I had very much stress when using IF or LOOKUP when there are numbers with a floating point error in it.

    https://youtu.be/SX-h_BYjpuM ... it is German, but look at minute 2:00 - this problem is allways present.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    This is an interesting idea. We’ll consider it during our next round of planning for a future release. In the meantime, please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

    Andreas Thehos shared this idea  · 
  11. 14 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
    Andreas Thehos commented  · 

    Hi,
    in former times I used a VBA-Code to Change crosstabulated data to lists. You can see the code on this site http://thehosblog.com/2014/01/28/excel-kreuztabelle-per-vba-in-liste-umwandeln/ and there is also a download possibilty for the xlsm-file.

    But if you can use PowerQuery or if you use Excel 2016, there is allready a functionality included to unpivot crosstabulated data. You have to unpivot your crosstable first an then you can use it for your PivotTable.
    Best regards from Germany
    Andreas

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

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    Andreas Thehos supported this idea  · 

Feedback and Knowledge Base