Moving from Excel 2010 to latest version

EE Pros,

I'm currently contemplating moving from Excel 2010 to the latest version of Excel.  I have a significant WB that runs very well in 2010 and I'm expecting will run equally as well in Excel 2013 or Excel 2016 (when available).  

Here is my question;  If I have Excel 2010 users and I use Excel 2013, when I save my WB, will they be able to run it in 2010 or will there be major issues?  Can I save it in 2010 format for compatibility?  OR, should I simply keep developing my WB in 2010 and only use 2013 on my personal machine to run the WB (not develop)?

Any guidance would be appreciated.

B.
Bright01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

[ fanpages ]IT Services ConsultantCommented:
Hi B...

This recent thread may me useful to you:

"VBA - How do I develop macros in Excel 2013 for Excel 2010 clients"
(Question by: ThomasMcA2 On 2015-07-28 01:09 AM)

[ http://www.experts-exchange.com/questions/28700707/VBA-How-do-I-develop-macros-in-Excel-2013-for-Excel-2010-clients.html ]

To answer your question, though, depending on the VB(A) Project References within your existing MS-Excel 2010-based workbook, you may have to change these specifically for the later version; for example, if you use any explicit MS-Office Automation Libraries for MS-Excel 2010.

It is more-than-likely that you will not need to do anything though.

The file formats for MS-Excel 2010 & MS-Excel 2013 (as well, as MS-Excel 2007) are the same:

".xlsx" (The default XML-based file format for Excel 2013, Excel 2010, and Office Excel 2007; can't store VBA macro code or Microsoft Excel 4.0 macro sheets)
".xlsm" (The XML-based and macro-enabled file format for Excel 2013, Excel 2010 and Office Excel 2007)
".xlsb" (The binary file format for Excel 2013, Excel 2010 and Office Excel 2007)

".xltx" (The default file format for an Excel template for Excel 2013, Excel 2010, and Office Excel 2007; can't store VBA macro code or Excel 4.0 macro sheets)
".xltm" (The macro-enabled file format for an Excel template for Excel 2013, Excel 2010, and Office Excel 2007)

With support for previous workbooks with the ".xls" file extension (formats; Excel 97–Excel 2003 Binary file format, & Excel 5.0/95 Binary file format).

Further information can be gained from the links below:

[ https://support.office.com/en-us/article/File-formats-that-are-supported-in-Excel-a28ae1d3-6d19-4180-9209-5a950d51b719 ]
[ https://technet.microsoft.com/en-us/library/dd797428.aspx#section2 ]


The quick answer is just continue as you are presently.  No changes are necessary in this regard.

However, to confirm, what file format (or formats) are you using now, in MS-Excel 2010?

Also, it is advisable to develop applications within the "lowest common denominator"; the oldest platform used by any of your user-base, but test in all platforms (where feasible) prior to implementation.  This means you have the greatest chance of compatibility across all platforms.  Developing in a later version of MS-Excel, & attempting to move backwards to earlier revisions (at run-time) may lead to issues with the use of functionality not available in previous versions, a different colo(u)r scheme/palette, or any number of features introduced in later revisions but not supported by previous versions of the product.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
I'm using XLSM consistently.

Great commentary.

B.
0
Bright01Author Commented:
Complete and very directive.  Much thanks.

B.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.