The fully formatted report is rendered in to a new workbook.
Note that the management report may contain a number of grids, charts, text objects and images laid out across one or more pages. All those objects are brought in to the Excel workbook upon import.
Text boxes in the report are converted to images in the imported Excel worksheet. In some cases, you may need to manually resize the image box in Excel to match the report presentation. To resize an image, use Excel's image formatting tool. Right-click the image and select Size and Properties. In Format Picture, set Scale Height and Scale Width to 100%.
If the report contains prompts, continue with step 4. If the report does not contain prompts, continue with step 5.
Note:
When you edit prompts, edit the POV, or refresh the report, the current workbook is closed and a new workbook is generated. Any unsaved changes in the current workbook will be lost. For example, if you performed an Analyze on one of the reports in the workbook, then the ad hoc grid will be lost when you edit the prompts. To keep any unsaved changes in the workbook, save the workbook, and then proceed to edit the prompts, edit the POV, or refresh the report.