Pro SharePoint Solution Development: Combining .NET, SharePoint, and Office 2007

Chapter 6. Integrating Spreadsheets into the Enterprise

Information workers have become accustomed to modeling business calculations with spreadsheets in Microsoft Excel. These spreadsheets may be updated on a time interval and distributed throughout the organization. This distribution is likely through email. There are many consequences to this strategy. Since there are so many copies of the spreadsheet, the organization loses its sense of what the authoritative version is. The spreadsheets themselves may be very large and laden with computations that make it unresponsive on an average desktop computer. In addition, the distributed spreadsheet contains the formulas and calculation logic that may be intellectual property that needs to be protected. ...