Specified Named Range '_xlpm.r' Does Not Exist in the Current Workbook

Kellen Fields
Kellen Fields
  • Updated

Published Date: 7/20/206
Audience: Everyone
Products and Versions Covered:

  • Jama Connect Interchange™ version(s)- All
    • JCI Module: 
      • Excel Functions

Summary

When syncing an Excel spreadsheet via a JCI integration, the sync stops with an error message:


ERROR
message 
Sync task failed: org.apache.poi.ss.formula.FormulaParseException: Specified named range '_xlpm.r' does not exist in the current workbook.
org.apache.poi.ss.formula.FormulaParseException: Specified named range '_xlpm.r' does not exist in the current workbook.

Resolution

_xlpm.r is an Excel workbook contains a formula, macro, or external reference that expects a named range called _xlpm.r, but that name is missing.
 
The term _xlpm.r is typically a reference to Excel parameters ( used for modern Excel formulas (like LET and LAMBDA), combined with the statistical correlation coefficient r.
 
You will need to troubleshoot the Excel spreadsheet for this  _xlpm.r and resolve. A few steps to check:
 

  • Broken named range
    • Open Formulas → Name Manager (Ctrl + F3).
    • Look for references to _xlpm.r or names with #REF!.
    • Delete or correct any invalid names.
  • Corrupted formulas
    • Press Ctrl + F.
    • Search for _xlpm.r in formulas.
    • Replace or fix any formulas referencing it.

Additional Resources 

Feedback:
We welcome your input! Please sign in to leave any comments, suggestions, or ideas for improvement below.

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.