OLAP Query continously running

davidben13

New Member
Joined
Jul 31, 2012
Messages
12
Howdy, I built a little powerpivot dashboard yesterday and all went well.

I re-opened it today and it's continously running the "OLAP query" over and over and over again.

Any idea what's going on?

-David
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
2010 or 2013? Can you hit Esc enough times to make it stop?

I would close down, and make sure you don't have any stray excel processes running (use task manager to kill them).
 
Upvote 0
2010 or 2013? Can you hit Esc enough times to make it stop?

I would close down, and make sure you don't have any stray excel processes running (use task manager to kill them).

2010, and i can hit esc and it stops. But when i click in the pivot table it just starts alll over again. Closed down, and computer restarted. I even rebuilt it from scratch...and it's still doing it.

:( bummer...This is a real PITA
 
Upvote 0
Wow, that is crazy that you could reboot, rebuild and still see it. Seems to maybe suggest a bad install of power pivot? Maybe try a re-install?

I have not seen that in 2010 (I've seen vaguely similar in 2013, but not 2010).
 
Upvote 0
Wow, that is crazy that you could reboot, rebuild and still see it. Seems to maybe suggest a bad install of power pivot? Maybe try a re-install?

I have not seen that in 2010 (I've seen vaguely similar in 2013, but not 2010).


It's weird, but i just realized it always says "Running OLAP Query" 10 times

i click somewhere else...it refreshes 10 times, then stops until i click in the table again.

What gives Microsoft??
 
Upvote 0
2010 or 2013? Can you hit Esc enough times to make it stop?

I would close down, and make sure you don't have any stray excel processes running (use task manager to kill them).

Completely Removed and re-installed powerpivot...still the exact same issue :(
 
Upvote 0

Forum statistics

Threads
1,224,034
Messages
6,176,001
Members
452,695
Latest member
Alhassan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top