Forum Discussion

VT733's avatar
VT733
Occasional Reader
Feb 02, 2026

Excel XIRR fails in Desktop & Online — ATP not binding, cloud profile corruption

I need help from the Excel engineering team. My Microsoft 365 account appears to have a corrupted Analysis ToolPak (ATP) function binding for XIRR at the cloud profile level.

 

Symptoms:

- =XIRR({-100,110},{1,2}) returns a long fallback constant instead of 0.1

- GET.CELL reports XIRR as invalid

- Excel Online produces the same incorrect fallback value

- Desktop Excel produces the same incorrect fallback value

- A brand-new Windows user profile produces the same result

- A full uninstall/reinstall does not fix it

- ATP is enabled and ANALYS32.XLL is present

- No Name Manager overrides, no LAMBDA overrides, no VBA, no add-ins

- Dates are valid Excel serial numbers

- All local Office registry keys, Feature Store, and activation tokens were wiped and rebuilt

- Excel is fully activated and licensed

- The issue persists across all environments

 

Because Excel Online returns the same fallback constant, this is clearly not a local machine issue. It appears to be a cloud-side Excel profile corruption, specifically the ATP function registry for my Microsoft 365 account.

 

Request:

Please escalate this to the Excel service engineering team to reset/rebuild my Excel Online profile and ATP function map for my account.

 

Thank you.

Bob

No RepliesBe the first to reply

Resources