This document will show you how to modify your report session to view reports in Microsoft Excel.
- Click on the TEMPLATE REPORTS tab and then click on Report Session in the Common Tasks
- Click on the gadget beside "Application to view XML reports:" and navigate to the Microsoft Excel program file as shown below:
- The path may vary depending on what version of the Microsoft suite you have. Here are a few examples of paths Excel might be installed in:
- C:\%Program Files%\Microsoft Office\Office9\EXCEL.EXE
- C:\%Program Files%\Microsoft Office\Office10\EXCEL.EXE
- C:\%Program Files%\Microsoft Office\Office11\EXCEL.EXE
- C:\%Program Files%\Microsoft Office\Office12\EXCEL.EXE
- C:\%Program Files%\Microsoft Office\Office14\EXCEL.EXE
- C:\%Program Files%\Microsoft Office\root\Office16\EXCEL.EXE
- Be sure to save your report session settings. The next time you view XML reports; Microsoft Excel will open.
Please note that if you wish to continue using the stylesheet in Microsoft Excel, you must open the file with the stylesheet applied as shown below: