What do Update All and Update selected actually do?

[masplin]

Related to my horrific problem below can someone just tell what exactly it is doing as takes over 30 mins to process an Update All. Since I can see a huge amount of memory being taken up I have assumed it is completely rebuilding the data set and recalculating every measure in the powerpivot window. Is this correct?

for update selected I have assumed it updates the data in the specific table, but recalculates ALL the measures in the powerpivot model. Again is that correct?

Thansk for any clarify as really struggling to understand what is going on.

Thanks Mike

 

[miguel.escobar]

Same as Refresh and Refresh All
For Refresh = refresh (Updates) current selection
For Refresh All = refresh (Updates) each found in the current workbook

 

[masplin]

yes but question is does it actually overwrite the data or check if the data has changed and if it hasn't pass over it?

 

[miguel.escobar]

Good question! I believe it actually runs the whole calculation all over as it has to check if the datasource is the same, what's the data available (not just the new one), resize some objects, etc.

Refresh PivotTable data - Excel - Office.com

Check out the link above

 

[Jacob Barnett]

My understanding is that on a PowerPivot workbook when it comes to refreshing Pivots and/or cube formulas, 'refresh all' and 'refresh' do the same thing.

I am unaware of a way of just refreshing a single PowerPivot pivot.

 

[masplin]

sorry I'm talking about updating tabs within the powerpivot window. You can chose "update selected" which I believe means the tab you are on or "update all". The reason i ask is because when I update without changing any data i get no errors. When I add an "s" to some text it blows up with duplicate or incompatible data error. Makes absolutely no sense if the update loaded all the data in fresh as clearly adding an "s" wouldn't damage the data (the field is not in a relationship)

 

[miguel.escobar]

extremely weird. Update (without the s) it's to update the active (current) table and the one with the (s) at the end it's to refresh all the tables. Perhaps one of your tables has incosisten data, try refreshing one by one and you can go from there.

 

[masplin]

This is bizarre. Basically our system outputs a csv each week and I paste the csv into excel. I tried pasting the first 5 columns in (41,000 row) and it throws and error. I closed the workbook unsaved, reopened and then pasted just column 1. Fine. Then column 2, then 3 then 4 etc. All fine. I then copied all five agian . Still fine. I am 100% sure there is nothing wrong with the data or the measures as the data I am pasting in is identical to the data i pasted in 11 days ago when I did the EOM. This means it is something to do with enviroment e.g. memory or something. I have absolutely no idea how to find it.