Feedback by UserVoice

Malcolm

My feedback

  1. 1 vote
    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 Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Malcolm shared this idea  · 
  2. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm commented  · 

    Couldn't agree more. It has been a real productivity waster for years, having to reset the panes every time.

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

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  4. 1,033 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

    Malcolm commented  · 

    Given that Power Pivot is becoming an ever more promoted part of Excel and Power Pivots and queries often depend in user input tables, it is absolutely mind-boggling surprising that this gross oversight has not been fixed.

    Malcolm commented  · 

    Getting even more important now that Bi and get & transform are becoming an everyday tool. We critically need to be able to protect the cells around these tables whilst allowing rows and columns (don't forget pivot tables) to be added and deleted.

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

    We’ll send you updates on this idea

    Malcolm commented  · 

    It has been suggested for a long time now that Excel introduces Regular Expressions into search and replace. This would solve the issue at a stroke as well as allowing for more flexibility throughout. It's all there in VBA already, how hard would it be to implement in the Search and Replace box?

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Good news! We have released a few fixes to Insiders to address this issue. If you are on Insiders, please let us know if the fix has worked for you.

    The fixes should be in build 11809.10000 and onwards.

    -Joe McDaid [Excel Team]

    Malcolm commented  · 

    Totally agree with this. Extremely tedious.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  13. 42 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  17. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm commented  · 

    Please fix this. I just encountered it and it is a pain. Somebody has added, not unrealistically a total row to a table I use in PowerPivot and suddenly I find all the numbers in my analysis are wrong because the import thinks the total row is a data row!

    You can't filter it out after the import as the row might be called something other than the default "Total" and the cells might contain Averages or one of the other options rather than Sum. There is an option to include/exclude headers. Why not an option to include/exclude total rows. This seems like a major oversight and I am puzzled why it has not been fixed in over a year.

    Surely it is not too difficult to allow:
    Source = Excel.CurrentWorkbook(){[Name="myTable"]}[Content]
    to be modified to specify the elements to be imported as in:
    Source = Excel.CurrentWorkbook(){[Name="myTable"]}[[Headers],[Data]]

    Malcolm supported this idea  · 
  18. 666 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 again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base