View Log

During any processing, various logging information is recorded. If the Spreadsheet Server Settings option Enhanced Logging is selected, the system records additional error message logging data. Log entries may be viewed, copied, or emailed.

1. In Excel, from the Application Configurator Ribbon, select Options> View Log. The Spreadsheet Server Log Viewer window appears, displaying the level, date, time, task ID, and description for each log entry. Additionally, in the bottom-right corner, the panel displays a count of the number of entries listed.

Tip: This panel may also be accessed by clicking the View Log button in the Spreadsheet Server Settings > General panel.



Note: To select a different time format or font size, select the respective drop-down list in the bottom-right corner.

2. To copy selected records to the clipboard, in the Log Viewer panel, select the desired record(s), then, either click the Copy Selected Errors, or, right-click and select Copy Selected Errors. To:

• Copy a single record: select the desired record.
• Copy select multiple records: press and hold the Ctrl key, as records are selected in the list.
• Copy multiple records in a range, select the first record in the range, press and hold the Shift key, then, select the last record in the range.

3. To email the entire log file to the helpdesk, click the Email Error Log button. The system opens a new Outlook message window, with the log file attached. Modify the email address and/or text of the email body as necessary, and click the Send button.

Note: When emailing the log using the View Log button, system information is automatically added to the body of the email.

4. To filter the entries in the log file, select the desired message type(s), date or time range, containing text, class, method, and/or task ID in the Filter section. Click the Clear Filter button to reset all filter fields to their default value.
5. To search for a specific value in the log file, type the desired value in the Find What field, and click the Find Next button. The system highlights the first log entry containing the value. Click the Find Next button again, to find the next occurrence of the selected value.
6. To clear the log file, click the Clear Log button.
7. To display the full details of a log entry, double-click the selected entry in the list. The Message Details panel appears. Click the arrow buttons in the Message Details panel to scroll up or down through the log entries in the list. To copy detail data for a single log entry to the clipboard, click the Copy button. Click the Close button to return to the Spreadsheet Server Log Viewer panel.
   
8. To download the logs onto your local machine, click the Export All button. You can locate the file in the Downloads folder.