Excel 2010 vs. 2016?

Hi,
Upgrading from 2010 to 2016 should not cause any problems.
However you should install the 2016 32bit version and NOT the 64bit version.
The 64bit version is only needed if you are working with very large files. (+ 2GB) and the macros, code from 2010 will give error messages in a 2016 64bit office.
(Even Microsoft doesn't recommend using the 64bit version)
Windows 64 and Office64 are 2 completely different things.
It is not the case that if you work with windows 64 you have to install the office 64.

Originally Posted by dotchiejack

and the macros, code from 2010 will give error messages in a 2016 64bit office.

That's pretty misleading, in my opinion. The only things that should give you real problems are if you use API calls, which need a little rewriting, or ActiveX controls that aren't from the MSForms library, since there are rarely 64bit compatible versions available.

Welcome, glad to help

@ Roya,
As far as I know, there is no 2010 64 bit and there is a very good chance that you will get errors if you use64 bit in 2016 with code from 2010. There is nothing misleading about that.

There is a 64bit version of 2010, but that doesn't make a difference. Regular code should work just fine in 32 or 64 bit.

As far as I know, there is no 2010 64 bit and there is a very good chance that you will get errors if you use64 bit in 2016 with code from 2010.

There is. I've used it before transitioning to Office 365.

But really, only issue will be as rorya stated. API calls and ActiveX not in MSForms.

Though I agree, 64 bit install is only needed for very specific pool of users (Data analysts that use 800Mb + data model, developer that should test for both environments etc).

Most common API calls can be converted easily to work on 64 bit. Although, there are libraries that was written in VB6 that can't be made compatible with 64 bit (unless recompiled).