Working with Spreadsheets

Use this page to navigate, view, and use a spreadsheet. Except where noted, the information in this section is applicable to all spreadsheet types. You can view or publish the spreadsheet from this interface, or you can open the spreadsheet in Microsoft Excel and save, print, or edit the spreadsheet.

Menu bar
The menu bar organizes tasks that you can do with the Spreadsheets component. To select a menu, click its name or use the ALT key combination indicated by the underscore (_) in the menu name.
Publish
Click to publish the spreadsheet.
Return
Click to return to the parameters page.
Close
Click to Close the browser window.
Help
Click for more information about the Web Report browser.
Saving a Spreadsheet
  1. Click File > Save As on the browser menu bar.
  2. Navigate to the folder that you want to save the file in, and then enter the file name and file type in the Filename and Save As type select boxes.
  3. Click Save to save the file to the selected location.
Note: Click Save As every time you want to save the spreadsheet. Clicking the Save button on the Excel toolbar does not save the spreadsheet.
Printing a Spreadsheet
Click File > Print on the browser menu bar or the print button on the Excel toolbar.
Editing a Spreadsheet
Any changes you made to the spreadsheet while the report was open in Excel are not saved in Web Reporting. Edit the spreadsheet as required and then follow the steps in Saving a Spreadsheet.
Closing a Spreadsheet in Excel
Click Back to return to the Web Reporting spreadsheet interface.