Home Forums The XBRL API Bad or Expired Token in Excel

Viewing 0 reply threads
  • Author
    Posts
    • #200814
      David Tauriello
      Keymaster

      From a user:

      I frequently get “Bad or expired Token” even when the code worked moments ago. I am working in Excel. Usually when this happens, it seems to affect other cells as well.

      Short of closing and re-opening Excel, is there anything I can do to re-establish the add-in connection?

      There may be many causes for this – momentary network disconnects or abandoning a query before it completes (revising it while the initial query is still processing) are common causes.

      Excel has a reload option built into the task pane that should get you reconnected without closing and re-opening the application.

      To use this option, click in an empty spot on the task pane, then use the menu indicator at the top-right corner of the task pane and select the Reload option (see the red circle in the image below).

      After refreshing the task pane, go to the cell(s) where the =XBRL.showData() formula is used and add an asterisk before the equals sign, press enter, then remove the asterisk to re-initiate the query. You should be able to use Excel’s find and replace for this step if there are many queries.

      Consider building query URLs in one cell, and calling them with XBRL.showData from another cell ( =XBRL.showData(A1, “”, “”, “1”) – this lets you manage the query independent of its execution.

      context menu for task pane

Viewing 0 reply threads
  • You must be logged in to reply to this topic.

Upcoming XBRL US Events

Domain Steering Committee Meeting
Tuesday, April 15, 2025

Communications & Services Steering Committee Meeting
Tuesday, April 15, 2025

Data Quality, Corporate Disclosures & the SEC
Thursday, May 1, 2025

2025 Meta Model Improvements
Wednesday, May 21, 2025

Center for Data Quality Committee Meeting
Wednesday, June 18, 2025

GovFin 2025: Designing a Digital Future
Thursday, July 31, 2025