Skip to content

Intermittent ItemNotFound error calculating range (centralized mode) #6383

@dajduprat

Description

@dajduprat

Centralized mode - Triggering range.calculate intermittently triggers errors

An 'ItemNotFound' is intermittently raised while triggering a range calculate from a ribbon action

It doesnt happen with same addin in side load mode

Your Environment

  • Platform: PC desktop
  • Host : Excel
  • Office version number: Microsoft® Excel® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20266) 64-bit
  • Operating System: Microsoft Windows 11 Enterprise 10.0.26100 Build 26100

Expected behavior

range.calculate() shouldnt trigger any error

Current behavior

Intermittently the calculate triggered from a ribbon button is causing an error during the Calculate call :
excel-win32-16.01.js:25 Uncaught (in promise) RichApi.Error: The requested resource doesn't exist.
at new n (excel-win32-16.01.js:25:268587)
at n.processRequestExecutorResponseMessage (excel-win32-16.01.js:25:333822)
at excel-win32-16.01.js:25:331883

Steps to reproduce

A sample addin codebase to replicate the issue is available : https://github.com/dajduprat/rangecalc

  • The addin has to be deployed in centralized mode
  • Load the addin
  • Insert a sample entity from taskpane with Run link
Image
  • An entity is inserted in A1
Image
  • Repeat several clicks on Calculate range after selecting the A1 range
Image

Link to live example(s)

  1. https://github.com/dajduprat/rangecalc/blob/main/src/commands/commands.js#L83
  2. Currently deployed in github using this manifest

manifest.xml


Provide additional details

  1. A workaround consists of retrieving again the same range done here : https://github.com/dajduprat/rangecalc/blob/main/src/commands/commands.js#L67


Context

For our internal assets and functions we need to trigger calculate call on specific ranges

Useful logs

  • Console errors
    excel-win32-16.01.js:25
    Uncaught (in promise) RichApi.Error: The requested resource doesn't exist.
    at new n (excel-win32-16.01.js:25:268587)
    at n.processRequestExecutorResponseMessage (excel-win32-16.01.js:25:333822)
    at excel-win32-16.01.js:25:331883
    n @ excel-win32-16.01.js:25
    (anonymous) @ excel-win32-16.01.js:25
    (anonymous) @ excel-win32-16.01.js:25

  • Screenshots

Image

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.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions