Dear Russell,
1. We haven't tested Excel Exchange with macro-enabled workbooks. We'll investigate that and, in a future version of SAM, allow for working with the .xslsm filename extension if it does not cause any unforseen problems.
2. You can only use cell references (A5, B7, etc.) to refer to cells in the first worksheet in the workbook.
3. That's a bug -- we neglected to configure the tracking equipment cost ($, $/Wdc, and $m2) variables for Excel Exchange, parametric simulations, and other special simulation options. We will fix that for the next version of SAM.
4. That's another problem. The SAM input variable should show the value from the Excel workbook. We'll fix that too.
Thank you for letting us know about these issues.
Best regards,
Paul.