View or Refresh Local Cache

When spreadsheets are calculated, Spreadsheet Server stores the account balances in either the local or global cache database, based on the option in the user's Spreadsheet Server Settings. Spreadsheet Server looks at the cache for account balances prior to retrieving the information from the host. As a result, it may be necessary to clear and recalculate the cache file if any of the following items have changed since the prior calculation:

• Data on the host system
• Segment Lists
• Accounts Profile

While the workbook calculates, the Pending value appears in each cell containing a GXL formula, and the Processing status appears in the Excel status bar. Once all formulas are processed, the workbook is refreshed with the actual values and the status is changed to Ready.

View or Refresh Local Cache

1. In Excel, from the Spreadsheet Server Ribbon, click the Cache button. The Local Cache panel appears displaying cached records.

2. To refresh the account balances in an Excel session, the cache records must be cleared:
• Clear All: clear all records in the cache.
• Clear Selected Rows: to clear selected records, select the desired records in the grid.
• Clear Selected Sheet: to clear the cache of a selected worksheet, click the drop-down list, select the desired worksheet.
3. After the cache records have been cleared, the system assigns a default Recalculation Option. If necessary, click the down-down menu, and select a different recalculation option. These options are:
• Trigger Excel to recalculate workbook(s) after closing Local Cache
• Trigger Excel to recalculate worksheet(s) after closing Local Cache
• Do Not Trigger Excel to recalculate after closing Local Cache
4. Click Close.

See General Grid Features and Copy or Export Records for more information.

Clear and Recalculate Local Cache

In Excel, from the Spreadsheet Server Ribbon, select Cache > Clear Cache and Recalculate. The system clears and recalculates the local cache.

Clear and Recalculate Local Cache for Current Sheet

In Excel, from the Spreadsheet Server Ribbon, select Cache > Clear Cache and Recalculate > Current Sheet. The system clears and recalculates the cache of the current sheet only.

Clear and Recalculate Local Cache for Selected Cells

Select any cells in a sheet, then, from the Spreadsheet Server Ribbon, select Cache > Clear Cache and Recalculate > Selected, or, right-click and select Spreadsheet Server > Clear Cache and Re-Calc Selected Cells. The system clears and recalculates the cache of the selected cells only.