KB37082: How to assign a report to a specific cell in an Excel worksheet in MicroStrategy Office

This Technical Note explains how a report can be assigned to start it's composition at a specific cell using Strategy Office

1. Launch Strategy Office through Excel and connect to a Project Source and Project.
2. From Tools, selct Options and in the Strategy Office Options editor select Excel and select the 'Prompt for placement of report" option as shown below:

 
 
In the case of multiple reports, the editor provides different options as to the report placement whether in a new sheet, or on the same as shown in the editor above. Again, specific cells can be assigned for the different reports by selecting the "prompt for placement of next report" option.
When a report is selected for execution from Office, the user is prompted to modify, if required, the report name as
well as specify a specific cell in the Excel sheet to which the report will be assigned.
 

 
The report is displayed on EXCEL as assigned:
 

 
Depending on the options selected in the Office Editor for Excel, multiple reports can be displayed on the same sheet or different sheets in Excel.