Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)?

share|improve this question
    
Unless you use the Excel 2003 format what you want is NOT possible( at this time). –  Ramhound Feb 7 '13 at 16:22

1 Answer 1

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.

share|improve this answer
    
Even Word 2010 and Word 2013 have a problem. It has everything to do with using the 1.2 revision of the open standard that is used. Excel 2013 can open 1.1 documents but cannot save them. This means we have to wait until Word 2010 is updated with a compatability pack to support 1.2. This issue is well documented on tech articles. –  Ramhound Feb 7 '13 at 17:30
    
Sorry, MSFT has been excellent at allowing reading old documents, but horrible at writing old formats (it isn't too easy to shoehorn new functionality into the old format; besides, it doesn't get paid for old versions people can still continue using...). –  vonbrand Feb 7 '13 at 19:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.