Feedback by UserVoice

Andi

My feedback

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

    We’ll send you updates on this idea

    Andi commented  · 

    @Bernie Korcyzk, this suffers from the problem of dealing with "(blank)" appearing in the rows section of my PivotTable, and isn't dynamic if columns are added or removed.

    Andi commented  · 

    @Jon Pelter - I didn't want to bore people with all the detail of why I don't like Tables for this purpose, but seeing as it's you, I'll respond ;)

    First let me say I'm very happy to spent time carefully configuring data I care about, and in Workbooks where I want to carefully manage the structure.

    However, many of the pivot tables I produce are rough, quick summary tables using transient data of a large size - and based on the results in the Pivot I'll likely go and tweak my dataset and repeat the process until I've got a final dataset I'm happy with. Then in my actual report I'll name all the Tables semantically and reference things properly, etc.

    Basically, think of my suggestion as pertaining to Excel as data hacking tool, as opposed to report writing tool.

    My problem with Tables in data hacking mode is that they slow me down.

    1) Ctrl+T gets me a table but I still then have to either click "my table has headers" or tap TAB, Space, Enter. (Little things I know, but repeated become an irritant)

    2) Sometimes my iterated dataset returns fewer rows or columns than last time. Without Tables, from anywhere within my data, I can press Ctrl+A, delete and it removes all data, which I can then paste over the top. My dynamic range formula works out the size of the new range, I can refresh my pivot table and I'm away.

    With Tables I have to either:
    a) Select any cell within my data, press Ctrl+A, delete, paste my new data in (being careful not to accidentally include my headers again), then go and specify and delete the rows or columns I don't need anymore. Then I can refresh my pivot table. (If I don't remove the unused rows/cols I may get "(blank)" appearing in my row labels or duplicated column names)
    OR
    b) be very careful to select one of the headers, press Ctrl+A, delete, which deletes the entire table. I can then paste my new data in its place, but I can't refresh my PivotTable because the name of the Table is now different (eg "Table3" instead of "Table2"). So I have to reselect my PT range.

    My suggestion is simply to make PivotTables, on refresh, include any new adjacent rows/columns in a non-Table range. This would be similar to the External Data Range Properties option "If the number of rows in the data range changes upon refresh".

    Sorry for the length! Hope that clarifies my suggestion.

    Andi commented  · 

    Yeah, I know but it's a hassle when I just want to paste the data in and get on with it!

    Andi shared this idea  · 
  2. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andi commented  · 

    See also this request here (with votes) - you may wish to post this as a comment on there rather than a separate request:

    http://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8847742-fiscal-year

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

    We’ll send you updates on this idea

    Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!

    Cheers,
    John [MS XL]

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Andi commented  · 

    Definitely! I had this problem myself with the Timeline Slicer:

    http://superuser.com/questions/937972/can-i-customise-the-new-timeline-slicer-in-excel-2013

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

    We’ll send you updates on this idea

    Andi supported this idea  · 
  8. 179 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion, thanks David! And thanks to other people who took the time to clarify/comment on this one. There’s definitely room to tighten this experience up in a number of places. We’re getting a lot of traffic on the site, so please keep voting for the things you care about most to help us do a great job of prioritizing.

    Best,
    John [MS XL]

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

    We’ll send you updates on this idea

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Andi supported this idea  · 
    Andi commented  · 

    Here's how I get round this - you can do it automatically (although I agree a nice simple tool within Excel would be much better)

    http://stackoverflow.com/a/19422821/1607446

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

    We’ll send you updates on this idea

    Great suggestion E Bow. Thanks for taking the time to tell us about changes you’d like to see – we’re listening. We’ll take a look at this one. As always, folks should keep voting for the things they like the most – we’ll generally be prioritizing things according to the number of votes they get.

    Cheers,
    John [MS XL]

    Andi commented  · 

    As a comparison, if I highlight some text in my browser, then switch away, the selection is still visible but it changes colour to grey. Perhaps Excel could do the same thing, continue to show the selection but greyed slightly so you know that Window isn't active.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Thanks to everyone who commented on this topic. This is certainly an idea that we’ll consider, but in the meantime, I wanted to mention that if you can’t see all the sheet tabs, you can right-click on the navigation arrows to bring up the “Activate” dialog, which gives a scrollable list of the sheets, so you can select the one you want and navigate to it. I know it’s not exactly what’s being suggested.

    As with other ideas, we’ll look to see how many people vote on this, so vote for it if this is an area you want to see improved.

    Thanks,
    Steve (MS Excel)

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

    We’ll send you updates on this idea

    Andi commented  · 

    There is the TEXT() function?

    Or do you mean convert it to the words that number represents?

    eg
    A1 = £9,204.66
    =TEXTWORDS(A1)
    = "Nine thousand, two hundred and four pounds sixty six pence"

    Sounds tricky if you include units!

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

    We’ll send you updates on this idea

    Thanks for the suggestion Wyn! Thanks also to all the contributors to this thread for the thoughtful discussion and debate.

    Of the many lookup function requests, this is currently one of the highest ranking on UserVoice. Please keep the votes rolling in if you’d like to see this, it helps us prioritize new feature work.

    JoeMcD [MS XL]

    Andi commented  · 

    So something like this, where you don't have to even have the thing you're looking for in the first column of your lookup table?

    = TVLOOKUP (A1, [PersonName], [NumberOfThings], false )

    Lookup table:

    ID | PersonName | Age | NumberOfThings | City

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

    We’ll send you updates on this idea

    Andi supported this idea  · 
  18. 107 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Andi supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base