The expand operation fetches the child data that meets the criteria that you enter and inserts it into new rows in the workbook. This data may change over time e.g. you may expand a parent value and over time the definition of that parent is modified. Use the refresh expand button to retrieve the most recent data from Oracle as follows:
Highlight the entire range of expanded data.
This must include the criteria row that drives the expand operation e.g. the row containing the parent value.
Identify the segment number to GL Wand by selecting the relevant segment from the segment list dropdown.
Click the refresh expand button.
GL Wand will remove the old expand data and will refresh the expand with the latest information.
Please note that the expand operation formats the inserted rows in a particular way e.g. the segment values are indented. The refresh expand operation relies on this formatting in order to process correctly. If you modify the formatting of the expanded rows the refresh expand may not function correctly.