locked
PowerPivot DAX hourglass - how do you break out of it RRS feed

  • Question

  • I've a million rows in my Excel sheet - sometimes after typing in the DAX formula for a measure, I get an hourglass and it takes several minutes - how do you break out of it? The formula is good, except, I've too many row labels open, so even if is only 50,000 items in the Pivot table, it takes a long time. I've 8GB RAM, 64 bit Win7,  XLS size is about 50-100 MB. In the task manager, I see Excel using 25% CPU and 1GB RAM.
    • Edited by aargeekay Sunday, February 12, 2012 11:23 PM
    Sunday, February 12, 2012 9:56 PM

Answers

  • I see that ESC works
    • Marked as answer by aargeekay Sunday, February 12, 2012 11:30 PM
    Sunday, February 12, 2012 11:30 PM