Portability of workbooks between servers; what do you need?

[Alan Kirk]

It's been suggested that a useful topic of conversation would be "portability of workbooks". I haven't put this in the Enhancements sub-forum because this isn't about a specific enhancement, but rather a fishing expedition for what people might consider to be useful in this regard.

Specifically, it's about "what would make it easier to move workbooks /worksheets between environments"? For the most part I would imagine that this would involve movement from a development to a production one, but it could be between different production environments as well. Aspects to consider include (add as needed):
- Formulas
- Action buttons
- Active forms

A couple that I can think of:
- Being able to specify the server name in a single cell so that all formula references flow from that cell. Effectively this has already been done with effect from 9.4.1 FP1. DBRWs have always worked correctly using a cell reference syntax; the big problem was that SubNms didn't, though that was rectified in 9.1.4 FP1.
- Action buttons which open TM1 applications have the workbook reference in the format Server\WebsheetName.xls. This would make it problematic to shift between servers.

Anyone else?