Forum Discussion
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