The MicroStrategy Office preferences page allows you to specify refresh options for reports and documents exported to MicroStrategy Office.
You must have Administrator privileges to access this preferences link.
To access preferences, from the menu at the top of MicroStrategy Web select Preferences, then click Office. The following options are available:
Allow MicroStrategy Office to refresh Documents after exporting to Excel: Determine whether MicroStrategy Office can automatically refresh documents to display the most current data after they have been exported to Excel.
Allow MicroStrategy Office to refresh Reports after exporting: Determine whether MicroStrategy Office can automatically refresh grid reports to display the most current data after they have been exported to Excel.
Click Go to the MicroStrategy Office Installation Page for information about installing MicroStrategy Office on your machine.
From the drop-down list at the bottom of the page, apply the changes to the current project or all projects you have access to that are stored on the Intelligence Server and then click Apply.
Warning: Clicking Load Default Values will reset all of your preferences settings.