Hi
I can export a 2016 version file and make it 2003 version but how do I save a 2016 version as a 2013 version. The 2003 version has severe limitations on the cumber of columns.
Hi
I can export a 2016 version file and make it 2003 version but how do I save a 2016 version as a 2013 version. The 2003 version has severe limitations on the cumber of columns.
The 2016 format - .xlsx - us the same as 2013.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Starting with Excel 2007 all versions support .xlsx extension up to the lasted 2016 version.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
The latest version has functionality which 2013 does not have - waterfall charts, for instance. When a user with 2013 version opens a 2016 with comparability issues, they are unable to edit it as far as I can tell. How can I save a 2016 as 2013 (and presumably just 'loose' the odd incompatibility issue such as a waterfall chart)?
You can't.
As mentioned above, when it comes to saving a file, it is either pre-2007 (.xls) or 2007 and later (.xlsx), there is no way to save as different versions of .xlsx
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks