Feedback by UserVoice

Andrey Minakov

My feedback

  1. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Andrey Minakov commented  · 

    Excel should keep a name of a table at least.

    An error occurred while saving the comment
    Andrey Minakov commented  · 

    In a table reference, excel even kill the name of a table, not only a column!

    An error occurred while saving the comment
    Andrey Minakov commented  · 

    And for table as well, when it's changed due to change in a source query, e.g.

    Andrey Minakov supported this idea  · 
  2. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  3. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Andrey Minakov commented  · 

    It would be great to be able to use DAX for that.

    Andrey Minakov supported this idea  · 
  4. 25 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  5. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Andrey Minakov commented  · 

    Bryon, thanks for your comment. Yes, I refer to "plain" tables (Insert->Table of the Ribbon). Please could you say what do you mean under "Data" table? Data table of What-If Analysis?

    Andrey Minakov shared this idea  · 
  6. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  7. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov shared this idea  · 
  8. 649 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    An error occurred while saving the comment
    Andrey Minakov commented  · 

    Roman Emelyanov, thanks for your comment, and yes, this may help in many cases, but this method won't help if you 1. already opened some workbooks in an Excel copy and launched PQ, and 2. in case you have to change data in the same workbook. So the non-modal PQ window would be very useful.

    An error occurred while saving the comment
    Andrey Minakov commented  · 

    While working with PQ, you just cannot interact with Excel itself. Working with PQ may be a long process, and user may need to do just some things with other files in parallel. And quite often you may have some data / dictionaries for your PQueries in the same workbook, and while make the queries, you may need to change the data in Excel Workbook. Scenario when you have configuration parameters for your PQueries in Excel Sheet is not useful at all because PQ window in modal.

    Andrey Minakov supported this idea  · 
  9. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  10. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  11. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov shared this idea  · 
  12. 353 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for being able to protect Power Query with a password. This is a good idea, but we don’t think we’ll be able to support this in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    Andrey Minakov supported this idea  · 
  13. 129 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for suggesting this feature, but this is not something we’re likely to implement anytime soon. The reality is that this sort of feature only helps to keep honest folks honest, and doesn’t provide true security, because anyone with permission to a workbook can modify that workbook. For scenarios where the database really needs to be securely maintained, a better answer is to deploy the data model to either an Analysis Services server or to Power BI. By doing that, the data model (an AS tabular database) will be maintained independently of the workbook, and users will be able to connect to the database and query it from their Excel PivotTables but will not be able to modify it.

    Andrey Minakov supported this idea  · 
  14. 17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  15. 18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  16. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  17. 20 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  18. 194 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  19. 21 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov supported this idea  · 
  20. 12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    In December 2020, we posted that this issue was fixed, but a few months later we realized that the change caused an unwanted side-effect, so we had to undo the fix.

    We’ll keep monitoring votes on this. Sorry for the inconvenience caused by fixing it and then taking away the fix, but the side-effect of the fix was worse.

    The side-effect was that in some cases, adding a row to a table on one sheet could cause a data validation rule to be applied to cells on another sheet where it should not apply.

    Steve [Microsoft Excel]

    Andrey Minakov supported this idea  · 
← Previous 1

Feedback and Knowledge Base