Export a spreadsheet to an Excel workbook

Office Web Components

Export a spreadsheet to an Excel workbook

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. On the spreadsheet toolbar, click Export to Microsoft Excel Button image to run or switch to Microsoft Excel and display the data in a workbook.

Notes

  • Because Excel supports 256 columns and 65,536 rows, data in columns IW through ZZZ and rows 65,537 through 262,144 are not exported from the spreadsheet. You can, however, copy this data to more than one Excel worksheet.
  • When you export data from a spreadsheet to Excel, only the values and formulas are exported. Links that connect to other data on the Web page or to other Web pages are not retained in Excel.
  • When you export some spreadsheet number formats, the data in Excel is displayed with a custom number format. For example, the Yes/no, True/false, and On/off spreadsheet formats are displayed with custom number formats in Excel. For information about custom number formats in Excel, see Excel Help.