Exporting Multiple Sheets to Excel in VDM

Use Export Multi Sheet to export multiple VDM data areas into a single Excel workbook.

The available export selections depend on what is configured in the View.

Export Multiple Sheets

1. Run the View.
2. Select the Export/Print ribbon.
3. Under No Preview, select Export Multi Sheet.
4. In the Export window, select the data areas you want to include.

Available options can include:

• Details
• Summary
• Pivot
• Chart

5. Select Okay.

Select the data areas to include in the Excel workbook, then click Okay.

Save the Excel Workbook

After selecting the export items, the Save As window opens.

1. Choose the folder where you want to save the workbook.
2. Enter a file name.
3. Confirm the file type is Excel Files (*.xlsx).
4. Select Save.

Choose a file name and save location for the Excel workbook.

Important

Run the View before using Export Multi Sheet.

If the View has not been run, the exported workbook may not contain the expected data.

Also, only select data areas that are configured and populated in the View. For example, if the View does not contain a Summary or Pivot, those selections may not contain usable output.

Related articles

• Exporting Data from VDM
• How to Use Data Grids in VDM