How does BCP handle what’s often accomplished through links in standard Excel?
Companies will have multiple enterprise spreadsheets which can be all independent or connected to each other– they can even be inside the same spreadsheet and even have data that’s connected to multiple enterprise spreadsheets! There’s tremendous flexibility built into the BCP technology to match the flexibility of Excel itself and how many enterprise spreadsheets a company uses is tied to its business process requirements (which are already laid out in the existing spreadsheets which they use to work with BCP). For example, many companies have multiple spreadsheets (or tabs within a spreadsheet) to support consolidation of a budget rollup across multiple departments. With BCP, these can be combined into a single BCP and leverage BCP’s access control and consolidation capabilities to handle the consolidation process automatically. Each user would only see their data in their own local spreadsheet (or on the browser), but their changes would be rolled into a single BCP.
