Excel 32-bit vs. 64-bit Development
Posted on 2013-11-03
Greetings EE Professionals.
I'm developing a spreadsheet and wanted to make sure it ran in both 32-bit and 64-bit Excel. I'd also like to make it completely compatible with Excel 2007, 2010 and the latest version of Excel if possible. The workbook will contain complex macros, conditional formatting, data validation and range names. So here are my two questions;
1.) If I build it in 64-bit, is it compatible and will run in 32-bit mode? And vice versa?
2.) Is Excel, beyond 2007 compatible with previous versions? How about 2010?
Any other advice would be helpful.
Thank you in advance.