I am working with large excel files (for personal projects) and have been advised to install the 64-bit Office 2016 rather than the 32-bit Office 2016 for improved performance. I have read online that the Office 64-bit can have 'backward compatibility' problems but haven't found anything detailing these compatibility problems.
Unfortunately, I must use my own computer at work, where I produce complex excel files (by complex I mean large amounts of formulas and some basic macros) for work colleagues to use.
So, I have got two questions:
What exactly can 'backward compatibility problems' entail?
Knowing that my colleagues use Office 32-bit (and sometimes older than Windows 7), if I create these excel files on the 64-bit Office 2016, what kind of 'backward compatibility' problems could I expect, if any?
P.S.: I do not use any plug-ins and most people I work with don't even know what a macro is.