Feedback by UserVoice

Excel for the web

Welcome to the web version of Excel's feedback forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add Office Scripts to the native Excel Application

    I understand getting full blown VBA working on the web is extremely unlikely (impossible?).

    So - make Office Scripts run on native Excel (and other Office apps). That way we get

    1) One common development language across all Microsoft Office applications

    2) Support for Javascript/Typescript in native Office.

    39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    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

  2. Enable Office Scripts to refresh Power Query queries

    Allow Office Scripts to refresh Power Query queries. It'd be very helpful to automatically refresh data using Power Automate, but that platform cannot currently refresh data.

    24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    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

  3. Office Scripts with Visual Studio Code

    I want to use VS Code to Develop Office Scripts, like Office Add-ins.

    11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    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

  4. Online excel should be capable of at least opening password protected files, inter-linked excel workbooks, macro enabled workbooks

    Online excel should be capable of at least opening password protected files, inter-linked excel workbooks, macro enabled workbooks

    31 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add office scripts to shapes in Excel Online

    Assign script/Vba/macro to a shape in Excel online

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

    We’ll send you updates on this idea

    3 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    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

  6. Connect Office Scripts to Buttons

    Similar to Excel for desktop, mapping Office Scripts to a button on excel online would be incredibly useful.

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

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. Online Excel needs to have 'Name Manager as an option'

    The online Excel version does not have the 'Name Manager' option, which I use frequently for Macros and VBScript. To get the features I need, I end up having to open the application on my desktop.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. Enable Office scripts on the Home/Personal version of Office 365

    I need to learn Office/Excel scripts for work, so that I can update some older spreadsheets that are programmed with VBA. However I do not have the time at work. I would like to be able to play with this at home - I have a personal office 365 subscription, but cannot access the automate tab.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. bind office script to events

    bind custom functions written with office scripts to events such as "onChanged" as described in the documentation for addins:
    https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-events

    it's essential to enable automation

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for the feedback.

    Currently, events APIs are not supported within Office Scripts. One of the main reason is that events can be long running and scripts have a defined start and end points. Unlike an add-in, the script doesn’t stay in the background to listen in and act on the events.
    Could you please let us know how you’d utilize events API support? That will definitely help us understand the requirement better.

    Thank you
    Sudhi Ramamurthy
    Program Manager

  10. Add Macros features in Microsoft Excel.

    Add Macros features in Microsoft Excel.

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Excel online add-in deploy only to thin client

    Feature to deploy the Web Add-in per client (Thick /Online/Mobile).
    Currently, Central deployment pushes to all clients by default.

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add Layout and Subtotal formatting support for PivotTable Hierarchies

    I'm trying to create an Office script in Excel Online that formats a PivotTable. I am able to use the PivotLayout interface (and setLayoutType and setSubtotalLocation methods) to format the entire table, but there is no way to format an individual row or column hierarchy.

    You can do just that without code in Excel Online by right clicking on a pivot item or row header and using the subtotal and layout menu items that appear. It would be helpful if you could add support for formatting individual row/column hierarchies.

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. Why NOT just call it Excel script when all it'll do is run scripts for EXCEL ONLY!!

    Why NOT just call it Excel script when all it'll do is run scripts for EXCEL ONLY!!

    All documentation you have on this is pointing to Excel - frustrating!

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Demo script - return entire table content

    Would be good with a demo script showing how to return an entire tables content. Assume its something like
    let entireTable = workbook.getTables('Table1');
    return entireTable;
    Demo script could include converting data to table first, then returning entire data content.

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow VBA to Scripting

    I don't want to translate all my macros from VBA to JS! Help me!
    It'd be easier to adapt my VBA code to the limitations of Excel Online than to translate it to JS. Thanks

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. Sample Script To Add New Record From Other Locations in Sheet

    Sample Script To Add New Record From Other Locations in Sheet. I have a sheet used to fill out information and I want to use another sheet as a database and just add a new record to the next available Row.

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Enable macros and VB code, please! This is a huge concern for our team!

    Enable macros and VB code, please! This is a huge concern for our team!

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. Calling a worksheet function with Office Scripts

    I tried the below code similar to Office Addins.
    but "Can't perform requested operation" error occurred.
    I want you to be able to call worksheet functions with Office Scripts.

    async function main(context: Excel.RequestContext) {
    let sheet = context.workbook.worksheets.getActiveWorksheet();
    let range = sheet.getRange("A1:A4");
    range.values = [[10], [20], [30], [40]];
    let ave = context.workbook.functions.average(range);
    ave.load("value");
    await context.sync();
    console.log(ave.value); //error
    }

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

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. implement Office Scripts in other apps

    I want you to implement Office Scripts in Office on the web other than Excel.

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base