Possibility of exporting Excel 2013 to Excel 2010

[PierrieK]

own vofavorite ​

I have been working in <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(239, 240, 241);">Excel 2013</code> and added the functionality <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(239, 240, 241);">% of Parent Total</code> in one of my Pivot Tables. When trying to save this document in <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(239, 240, 241);">Excel 97-2003</code>, I get a 'Significant loss of functionality' warning and then I obviously lose this functionality when saving. Is there another way of doing this? I need to be able to save this spreadsheet as <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(239, 240, 241);">xls</code> and also keep all functionality.

<tbody>
</tbody>

 

[mole999]

are you trying to export so that you can use 2003 and before ?

 

[PierrieK]

are you trying to export so that you can use 2003 and before ?

No, I am trying to export to Excel 2010 so that I can keep all functionality on the spreadsheet.

 

[mole999]

then you need to save as xlsx, xlsm or xlsb. 2010 can handle those extensions as they are xml files, xls is a different file format hence the system warns of compatibility issues.

 

[PierrieK]

then you need to save as xlsx, xlsm or xlsb. 2010 can handle those extensions as they are xml files, xls is a different file format hence the system warns of compatibility issues.

Thanks
Think I should try a work-around to this.