To my utter surprise, when saving in Excel 2013, then re-open in Excel 2010, you can't edit any of the numbers 'because this document was created in a newer version of excel'.
There is no option in the 'save as…' dialog.
Can anyone get Excel 2013 saved files to work on Excel 2010 (including pivot tables)?
Best Answer
Looks this is an issue with the new Pivot Table Model in Excel 2013. See Version compatibility between PowerPivot Data Models in Excel 2010 and Excel 2013. Normally Microsoft is very good about maintaining compatibility between recent versions. Looks becuase of the functionality for Pivot tables they had to break it.