Having to update data model twice before complete update

[cr731]

I'm using PowerPivot and the data model. Some of the calculations in my calculated measures rely on inputs of other tables (for instance, I have an exchange rate table, as a linked table inside the data model, and then those exchange rates are used in some calculated measures of the PowerPivots). I'm finding that I have to refresh the file twice in order for the fully updated values to be displayed. It seems that update # 1 is needed to update the exchange rate table within the data model, and then update # 2 is needed so that the calculated measures use the updated exchange rates.

This gets kind of confusing to me when writing macros to update the file... is this normal behavior or is there a way I can update everything in a single line and ensure all calculations are updated properly?

 

[TimRodman]

Are you using the Data -> Refresh All button on the ribbon in Excel 2013? And you have to click it a second time after the first refresh is finished?

 

[cr731]

Are you using the Data -> Refresh All button on the ribbon in Excel 2013? And you have to click it a second time after the first refresh is finished?

That's correct.

 

[TimRodman]

I have had the same issue before, but it doesn't seem to happen all the time. I haven't been able to determine when it happens and when it doesn't.