Refresh problems Excel 2013

Vikinger

New Member
Joined
Apr 22, 2013
Messages
5
Hi all! I tryed to convert a powerpivot from excel 2010 to 2013. I've delete all excel sheets which contains pivot tables and graphics. At this point, the refresh of the data (sql db, linked excel tables) works prober. Then I've rebuilded the excel sheets which contains the data of the powerpivot datamodel. As long as I've less then 5 Excel sheets it works prober. But if I add more sheets, I cannot refresh my data. In the excel sheet I see the message "data will be readed" (daten werden gelesen in German :cool:). Is there a limit of sheets or tables? On every sheet I've two pivot tables and one or two charts. In Excel 2010 it works proper... Can anybody help? Sorry, for my bad english! Regards, Vikinger
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Vikinger

New Member
Joined
Apr 22, 2013
Messages
5
Hi all, I found the mistake. There are some messures which run with Excel/Powerpivot 2010 but looks like they dont work with 2013. Every time I divide or multiply two or more messures each other, I get the refresh problems. The strange thing is, that he calculat it correct. As long as I dont have those messures linked on a power pivot table in the excel sheet, I can refresh the data model. Any body the same problems?
 

Vikinger

New Member
Joined
Apr 22, 2013
Messages
5
Sorry for the multiple postings... :)
I've build now the report completly new in Excel 2013. And I've located now the problem. To get the percentage deviation between two numbers, I calculate measure vs. measure. This works fine. But if I add a iferror dax to this formula, powerpivot run into a loop when trying refresh the data from SQL server. As long as I have this measure just in the datamodel it works proper. But as soon as I add this measure to a powerpivot in Excel, I get the refresh problem! The same problem (loop if I want to refresh) if I calculate and show a KPI in a pivot table. Any ideas???? In Excel 2010 the same formulas work proper!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,150
Messages
5,835,685
Members
430,376
Latest member
eeehhhyyy

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
Top