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. 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 →
  2. 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 →
  3. 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 →
  4. 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.

    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 →
  5. Office Scripts with Visual Studio Code

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

    7 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

  6. ExcelScript.SumIFS

    SumIF is already supported in Excel for the web, but not supported in ExcelScript.

    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 →
  7. Enable WorksheetFunction in theOffice Script

    Enable WorksheetFunction in theOffice Script

    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 →

    Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.
    For now, worksheet functions are not yet enabled.
    Worksheet functions requires some additional work for us to expose. We are going to look into that in the coming weeks and understand the work needed little better.

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

  8. Enable Office Scripts to set password protect to hide the program scripts

    Enable Office Scripts to set password protect to hide the program scripts

    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 →
  9. Enable Office Scripts to activate ActiveX objects, Forms

    Enable Office Scripts to activate ActiveX objects, Forms

    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 →
  10. Add office scripts to shapes in Excel Online

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

    4 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 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

  11. 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.

    5 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 →
  12. get the last cell in contiguous range of non-empty cells

    I'd like you to add a method for get the last cell in contiguous range of non-empty cells.

    even like the 'End' property in VBA are okay.

    With ActiveSheet
    Set rng = .Cells(.Cells(.Rows.Count, 1).End(xlUp).Row, 1)
    End With

    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. 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 →
  14. 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

    4 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

  15. 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.

    22 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

  16. The ONE Drive app should have the Quick Access bar and if I log into MS & Excel why can't the quick access be synced

    1) The Quick Access Tool Bar should follow my login into any MS product and 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 →
  17. visibilidad, lenguaje de programación

    Tienen que trabajar en que se vea la hoja de calculo más amigable, no se ve el "zoom", necesitan trabajar el lenguaje de programación online

    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. Automatic timestamp in excel online

    =IF(B2<>"", IF(A2="",NOW(),A2), "")

    For the above function;
    1. Is this possible to make it work in EXCEL online?
    2. AND if it is possible to use multiple cell for the "logical test" of that function

    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 →
  19. Add Macros features in Microsoft Excel.

    Add Macros features in Microsoft Excel.

    9 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. 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 →
← Previous 1 3
  • Don't see your idea?

Feedback and Knowledge Base