Feedback by UserVoice

Andreas Thehos

My feedback

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

    We’ll send you updates on this idea

    Andreas Thehos commented  · 

    Actually I have to edit any data label manually or to use the free XY Charts Labeler-Addin. Pleas make value from cells availible, it is such an important function!

    Andreas Thehos supported this idea  · 
  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andreas Thehos shared this idea  · 
  3. 89 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  · 
    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

  4. 1,037 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

    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

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

    We’ll send you updates on this idea

    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

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

    We’ll send you updates on this idea

    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  · 
  7. 62 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  · 
  8. 26 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  · 
  9. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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

  10. 901 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