Excel 32-bit vs. 64-bit Development
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.
B.
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.
B.
ASKER
I have it written in Excel 2010 32 bit; .xlsm. People with excel 2007 are having problems opening the WB......
B
B
The two versions have completely compatible file formats, so you must be using a function not backward compatible. I keep separate machines on my laptop with different versions of Office to test .
Try stripping out some functions to regain compatibility.
.... Thinkpads_User
Try stripping out some functions to regain compatibility.
.... Thinkpads_User
ASKER
Would the formatting between xlsm and xlsx make any difference?
B.
B.
I cannot directly answer that. You would have to try it. But keeping functions at a simpler level is likely to have more effect.
..., Thinkpads_User
..., Thinkpads_User
What kind of problems are they experiencing exactly?
ASKER
Thanks for asking! Well, I developed a very complex business model (Macros, Conditional Formatting, Splashscreen, data validation, etc. etc.) in 32-bit Excel 2010. I've used LOCKXLS which is suppose to be completely compatable with 32 or 64 bit Excel 2010 to create a EXE file. When people open the file they get a runtime error....but generally only when running 64-bit Excel.
That spawned the question.
B.
That spawned the question.
B.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll need to set up another Test environment outside LockXLS; great comments!
Thank you,
B.
Thank you,
B.
@Bright01 - Thanks for the update and I was happy to help.
.... Thinkpads_User
.... Thinkpads_User
2. The current format for Excel (.xlsx) is compatible across 2007, 2010, and 2013 (which I use).
A couple of things:
1. Most people (probably in excess of 90%) use 32-bit Office so that I recommend your base project be in 32-bit.
2. New versions might contains functions not in older versions (compatibility aside). So you need to test with older versions. Anything built in V2013 that works in V2007 will also work in V2010.
I send spreadsheets around from Excel 2013 and everyone can use them. If I need complete compatibility, I save as .XLS (old format).
.... Thinkpads_User