Static Snapshot Selection

This option will replace any Finsyte function call with the actual value for all cells in a selection. This technique is useful for capturing historic data as static values in order to prevent re-querying them each time the workbook is refreshed.

Simply select an entire row, column, range of cells, or an individual cell, right click and select Static Snaphot Selection.