Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.