Power Pivot take longer time to refresh the data

[aam1932]

Hai,

I want to know why my pivot table take longer time and some time hang when refresh the data ( using power pivot). For info, my data only around 80k rows.

thank you

 

[scottsen]

Where is the data coming from? Could that be causing the delay?

Otherwise, my only guess would be a poorly performing calculated column? Though, also... once they refresh is done it is probably updating your actual reporting sheets too, and that can take some time.

How many columns in your 80k row table?