Excel Web Only Issue: Existing bindings are not working in Excel Web when tried to reload and add a listener to them

[SenMS-CSA]

Added few cell change bindings with onDataChanged event, the binding will exist forever and whenever user starts the add-in again the bindings will be reloaded using bindings.load("items") and added the event listeners to them, this perfectly working in Excel Desktop but not working in Excel Web

Your Environment

• Platform [PC desktop, Mac, iOS, Office on the web]: Office on the Web
• Host [Excel, Word, PowerPoint, etc.]: Excel
• Office version number: 16.0.18325.42310
• Operating System: Windows 11
• Browser (if using Office on the web): Edge

Expected behavior

The bindings should work with event listener added back to them. If the user tries to change the cell value, the onDataChanged event added back should trigger

Current behavior

The event is not triggering and throwing an error

The events should trigger and execute

Steps to reproduce

1.Create a binding with onDataChanged event listener
2. Close the workbook and open again
3. run the code, execute a reload method for all existing bindings and add onDataChanged listeners using a button click

Link to live example(s)

https://github.com/SenMS-CSA/ExcelWebBindingsIssue/blob/main/Codesnippet

Provide additional details

Added the error screen shot

Context

The issue affects because the bindings have to be deleted and recreated every time rather than reusing it

Useful logs

• Console errors
  
• Test file (Excel for Office on the Web

Thank you for taking the time to report an issue. Our triage team will respond to you in less than 72 hours. Normally, response time is <10 hours Monday through Friday. We do not triage on weekends.

[guoms1]

Hello, SenMS-CSA

I’ve provided updated function below with some minor adjustments to enhance functionality and address a few issues. Please try replacing your existing functions with these to see if they help resolve the problem.

I’ve tested the updated code in an Excel Online add-in and it worked as expected without encountering the issue you described. If you have any further questions or need additional assistance, I’d be happy to help!

async function reload() {
    await Excel.run(async (context) => {
        const bindings = context.workbook.bindings;
        bindings.load("items");
        const getbinding = bindings
            .getItem('SalesByQuarter');
        getbinding.load("id");
        getbinding.onDataChanged.add(onSalesDataChanged);
        await context.sync();
        console.log("The bindings reloaded");
    });
}

Best regards,

[SenMS-CSA]

Hello, SenMS-CSA

I’ve provided updated function below with some minor adjustments to enhance functionality and address a few issues. Please try replacing your existing functions with these to see if they help resolve the problem.

I’ve tested the updated code in an Excel Online add-in and it worked as expected without encountering the issue you described. If you have any further questions or need additional assistance, I’d be happy to help!

async function reload() {
    await Excel.run(async (context) => {
        const bindings = context.workbook.bindings;
        bindings.load("items");
        const getbinding = bindings
            .getItem('SalesByQuarter');
        getbinding.load("id");
        getbinding.onDataChanged.add(onSalesDataChanged);
        await context.sync();
        console.log("The bindings reloaded");
    });
}

Best regards,

Hello, SenMS-CSA

I’ve provided updated function below with some minor adjustments to enhance functionality and address a few issues. Please try replacing your existing functions with these to see if they help resolve the problem.

I’ve tested the updated code in an Excel Online add-in and it worked as expected without encountering the issue you described. If you have any further questions or need additional assistance, I’d be happy to help!

async function reload() {
    await Excel.run(async (context) => {
        const bindings = context.workbook.bindings;
        bindings.load("items");
        const getbinding = bindings
            .getItem('SalesByQuarter');
        getbinding.load("id");
        getbinding.onDataChanged.add(onSalesDataChanged);
        await context.sync();
        console.log("The bindings reloaded");
    });
}

Best regards,

I am still getting the same error after replacing the reload function. I tested using script lab only and my file saved in one drive. If you need, I will share the file as well.

Regards,
Senthilnathan