Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel workbook that has 30 plus pivot tables and 10 plus slicers connected to PowerPivot. When we filter data based on these slicers the performance is sub par, 30 sec to 2 minutes. Is there a strategy for improving this performance?

share|improve this question

Things I did to improve the performance of my PowerPivot files:

  • check for unecessary calculated columns on table-level
  • check and re-check measures (is every measure necessary? are they calculated in an efficient way?)
  • are the slices only connected to the relevant tables and don't interfere with each other?

Another strategy could be to save a backup of the original file and delete some of those tables or slices step-by-step to narrow down if there is a specific set of slicers which are especially time-consuming and focuse on those first.

For more general statements than that it would be helpful to see some examples.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .