My Excel file makes extensive use of data tables, and I’ve got Excel’s calculation options set to “Automatic Except for Data Tables”. The file behaves exactly as I would expect when run as a pure Excel file (i.e., the data tables are only executed whenever one of my macros is initiated by the user); however, after being converted to an exe program, the data tables are run anytime the exe is brought up (actually, they’re run twice). This is very undesirable behavior. Can you help me understand what might be causing this? Thanks.
Is it possible for you to send us by email an Excel sample that shows your problem?