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. 301 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. 97 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. 14 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. 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  · 
  7. 194 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  · 
  8. 286 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  · 
  9. 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  · 
  10. 6 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

  11. 526 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  · 
  12. 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  · 
  13. 10 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!

  14. 746 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  15. 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  · 
  16. 114 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  · 
  17. 60 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. 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  · 
  19. 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  · 
  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