View or Modify Segment List Values in Excel

Spreadsheet Server allows users to view the values contained in a specific segment list from a worksheet. Users may also modify the values on the fly. Lists can be shared among all Spreadsheet Server users, so caution should be exercised when making modifications.

1. Select the desired cell containing the segment list, right-click and select Spreadsheet Server > List Accounts. The Segment List Maintenance panel appears, displaying the values for the selected segment list (seeCreate or Maintain Segment Listsfor more information).
2. Segment list values may be added or removed as necessary.
3. In the event values for the segment list are altered, it is recommended to purge the balances in the cache file of the segment list. To purge balances, click the down arrow under the Cache button, then Purge List.
4. Once all modifications have been made, click X. The panel closes and returns focus to the spreadsheet.
5. In the event balances were purged in the cache file for the segment list, the GXL formula, or, the local cache need to be manually recalculated (see Calculation Options and View or Refresh Local Cache for more information).