Creating a Static Copy

The Create Static Copy feature enables all the functions to be changed to static numeric values. In other words, the feature creates a snapshot of the data in the Excel workbook at creation time.

The feature creates a new Excel workbook, which is similar to the original workbook but all the formulas are replaced with actual values (values, which the formula restored just before creating a new workbook file).

Before creating the static copy, make a backup of your DR document. The changes cannot be undone.