Feedback by UserVoice

Ángel

My feedback

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

    We’ll send you updates on this idea

    Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.

    Excel for web doesn’t support VBA or macros. There is however a new scripting option if you are looking to automate your solution. Office Scripts is a new offering we released in public preview earlier this year. It offers recording and scripting capabilities based on TypeScript/JavaScript languages. Please check out https://aka.ms/office-scripts for details.

    Office Scripts doesn’t yet allow shape based triggers. It is something that is of interest to us. Could you please provide some details how how you wish to use this in Excel for web?

    If you have any questions, please reply back to this email.

    Thank you,
    Sudhi Ramamurthy
    suramam@microsoft.com
    The Microsoft Team

    An error occurred while saving the comment
    Ángel commented  · 

    Sudhi I would like to be able to execute a script written in Office Scripts when pressing a button in an excel spreadsheet

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

    We’ll send you updates on this idea

    92 comments  ·  Excel for the web » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Ángel supported this idea  · 
  3. 2,123 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    507 comments  ·  Excel for the web » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Ángel supported this idea  · 
  4. 39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.

    Office native platforms already supports JavaScript/TypeScript for the add-in (extensions) model. The built-in Office Scripts/automation is not yet supported.

    We do intend to support Office Scripts across other platforms and hosts. However, the priority and schedules for such expansion in coverage is not yet finalized. We are right now focussed on delivering it for Online platform with Power Automation support. Please stay tuned for future announcements to learn about the coverage.

    Thanks,
    Sudhi

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

    We’ll send you updates on this idea

    Hello,
    Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.
    We are in the process of developing VS Code Extension for Office Scripts. We are very curios to hear your feedback when we have the initial version ready for usability testing. Would you be interested in hearing from us on this matter? If so, please email me and I can reach out separately.

    Regards,
    Sudhi Ramamurthy
    suramam@microsoft.com

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

    We’ll send you updates on this idea

    Hello,

    Thank you for providing the feedback. Your input helps us in making the product better.

    Reg. Power Query refresh action – yes, this is in our backlog. We don’t yet have an API that can refresh a Power Query. We’re working with the product team to prioritize the API. I don’t have an ETA yet. But, we’ll be monitoring this closely and update our docs once the feature becomes available. Feel free to email me if you need more details.

    Thank you,
    Sudhi Ramamurthy
    Program Manager
    Suramam@microsoft.com

    Ángel supported this idea  · 
  7. 3,895 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    995 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.

    Refer to the following blog post for more details:
    https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840

    I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.

    An error occurred while saving the comment
    Ángel commented  · 

    "The latest Excel for Mac (v 16.29 and later) can refresh from Text, CSV, XLSX, XML and JSON files, but not when those files are on SharePoint Online (or other cloud storage locations). Please add this functionality, as we are moving to SPO and away from file servers. I know I can refresh from a local copy (via OneDrive sync client), but each person's local file path may be different, so a shared Excel file won't update correctly for each person."

    Same problem here!

    An error occurred while saving the comment
    Ángel commented  · 

    Waiting for this!

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

    We’ll send you updates on this idea

    123 comments  ·  Excel for Mac » Other  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion about the Data Form. We don’t have plans to implement this in the near future, so we’re marking it “Not at this time”.

    We recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you’re at the last field. If you’re on the last record in the table, it will add a new record to the end of the list.

    Please comment to let us know what other reasons you’re using the Data Form that make it easier/better than using a Table.

    Ángel supported this idea  · 
  9. 1,280 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    334 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

    I updated the title and description for this one and we’ll continue to monitor for comments and votes.

    Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality

    Steve K [MS Excel]

    Ángel supported this idea  · 
  10. 3,861 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    841 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for supporting this suggestion with your votes. It’s unlikely that we’ll be able to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS. We’ll keep tracking votes, since we know that the scenarios made possible by PowerPivot are important, even if the solution will need to be something else.

    Ángel supported this idea  · 

Feedback and Knowledge Base