Home Forums The XBRL API Calc! Error in Excel

Viewing 1 reply thread
  • Author
    • #201714
      Timur Mirzaev


      For some reason, my query, which used to work just fine (arguably, before the recent add-in update), now shows the “Calc!” error. What is even more unusual is that in a split of a second I can actually see the data appearing before being superseded by this very error.
      Apparently, this error can be replicated by having the full code written as a formula [ with references to other cells having, say, ‘fact endpoint’ and ‘textjoin(“,”, TRUE, concept name) formula for concept unification], while the XBRL.showData () is used separately to refer to that formula.
      Interestingly, if one “kills” the formula, so that the code is just a plain text, the error is gone, and data is extracted.

      I would very much appreciate any help around this issue.

    • #201818
      David Tauriello

      Hi Timur – this link might help you diagnose the #CALC! issue: https://exceljet.net/formula/how-to-fix-the-calc-error

      If you post an example of a query that’s not returning data, it will be easier to understand the issue you’re encountering.


Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Upcoming XBRL US Events

Communications & Services Steering Committee Meeting
Tuesday, December 19, 2023

FDTA Impact on Municipal Bond Investors
Wednesday, January 17, 2024