Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Wdata Query won't connect to Spreadsheet - How to troubleshoot?

Answered
0

Comments

1 comment

  • Steve Stegelin

    If a connected query won’t update the spreadsheet, a couple factors may be at play. To troubleshoot, first verify the query runs successfully in Wdata. If so, the query results may exceed the spreadsheet’s limit of 2,000,000 cells (that’s across all sheets or sections, not per sheet). Clicking on the connection's "warning" symbol can also provide some insight into the underlying cause. Hope that helps!

    0

Please sign in to leave a comment.