Help Center
Having Trouble? We are here to help.
Call: 1-855-ASU-5080 (1-855-278-5080)
   

Export Pivot Section to Excel (Hy11)


Last Updated:  8/3/12 11:41:01 PM 8373-8193-7056

After processing the report and retrieving results, information from a customized pivot section can be exported while maintaining its formatting.

Follow these steps to export a Pivot section into an Excel file.

*(watch a video demonstrating these steps)

  1. After processing the report and retrieving results, navigate to the existing Pivot section (or create a new one)..

     
  2. From the Pivot Section main menu, click on File>Export>Section.

     
  3. In the Export Section window, leave under Microsoft Office 2000 HTML (*.html) as the file type and save file to designated network location.

     
  4. Navigate to and select the file from the saved location. Right-click on it and select Open With>Microsoft Office Excel.
    (Note: If Excel is not immediately available, select Choose default program... and locate the Excel application in your available programs.)

     
  5. Once the file is opened the Excel program, be sure to save it as an Excel file.

     
  6. Delete the .html file from the saved location.
     

 

 



Improve the Help Center. Provide Feedback.
Did this article resolve your issue? *
Comments:
512