In the All Values View, you can view the element's values of all series and periods. The order of columns in this view is determined by the rules listed in the Values section of the Element View help topic.

 

Click the Edit All button to open the Edit Values View.

 

Click the Export to Excel button to export the view into a Microsoft Office Excel file. When opening the exported file in Microsoft Office Excel, answer "Yes" to the confirmation question.  Note that the decimal separator used in the export is taken from the web browser's settings, so Microsoft Office Excel should be configured to use that same decimal separator. However, if QPR Web Services Foundation is installed, there is an Export to Office link instead of Export to Excel.