When you export a document, you send its data to an external software application such as an Excel spreadsheet or to Adobe as a PDF displayed outside of the MicroStrategy Document Editor.
When a multi-layout document is exported to PDF, each layout starts on a new page. When exported to an Excel file, each layout is placed into a separate worksheet. If the PDF will be viewed on a Kindle or Nook, you should expand all layouts so that the Kindle or Nook user can view all the data.
Before you export, set the export options to control how the document is exported. You can specify whether to export only the current layout or all the layouts in the document. If you allow users to be prompted when they export a document, they can choose to export all layouts or only the current layout.
The remaining export options, such as page-by and whether to prompt the user before exporting, apply to all layouts in the document. For more information on exporting in general, see Exporting a document.
Open the document in Design or Editable Mode.
From the Format menu, select Document Properties. The Properties dialog box opens.
Click Export.
Select Export All layouts.
Click OK to return to the document.
From the File menu, select Export to Excel.
If the Export to Excel dialog box opens, ensure that Export All layouts is selected.
Click OK. The document opens as an Excel spreadsheet. Be sure to save it before exiting Excel.
Related topics