Microsoft ® Office 2007 Business Intelligence

2.2. Opening an Excel 2003 Spreadsheet in Excel 2007

Figure 2-1 shows a real-world spreadsheet for cell phone plans from the telecommunications industry, used to present phone plans to prospective customers. This spreadsheet does not have an overly large amount of data because it is meant to represent the Excel 2003 files that are commonly a part of today's working environment. (It should be noted, however, that whereas Excel 2003 could hold 65,000 rows, Excel 2007 can hold up to a million rows of data!) This chapter will help you understand how to use PivotTables and PivotCharts with your working spreadsheets as well.

The spreadsheet in Figure 2-1 is not connected to any data sources; all data is contained in the cells shown. Because this spreadsheet ...