Excel 2013 constanly recalculating workbook for no good reason

[masplin]

I have a data model I have successfully converted from Excel 2010. It is driving me nuts, as everytime I touch the data model like inserting a new column, editing the column title or even changing the date format it forces a complete refesh of the workbook and all the pivot tables. This does not happen in Excel 2010 where you have to actually request the refresh. It is obviously insane to refresh the pivot table if you change the format in data model from dd-mmm-yy to dd/mm/yy!!!! The only way to stop it is to select the workbook and hit escape 20 or 30 times to kill all the refreshes.


This is wasting so much time there must be a way to turn off automatic refresh and only refresh the workbook on command? I tried changing the whole workbook to manaul calulate, but this doesn't make any differnce ot this behaviour and just messes up the workbook. Please can someone tell me how to stop this as sure it can't be the right behaviour.



Thanks

Mike

 

[masplin]

Well I've made a really tiny file and you can see if you just change the number format the "Reading Data" flashes up in the corner. Because it is a tiny workbook with one pivot table it is over very quickly, but with a big workbook and lots of pivots I can wait a couple of minutes each time. Can I send it to you to check if you have the same?

 

[masplin]

its only 116kb so emailable

 

[miguel.escobar]

miguel.escobar@poweredsolutionsonline.com