You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smartview Query takes 15 minutes to run

edited Aug 29, 2018 5:01PM in Planning 5 comments

Summary

Smartview Query takes 15 minutes to run

Content

We have a user who created an excel workbook with:

  • 1 data tab that contains a Smartivew query - 349 Rows / 142 columns
  • 11 tabs that link to the Smartview data. These tabs include graphs, tables and some simple formulas
  • Workbook size ~2MB

It takes about 15 minutes to run the Smartview Query.

However, when I move the Query tab to a new workbook that only contains the Smartview query, then the query takes 3 seconds to run. Why is that?

Any suggestions how to speed up the query (if it is part of the workbook with the 12 tabs)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!