Procedure documentationCreating a Snapshot of a Worksheet or Workbook

 

As a security measure or for test or presentation purposes, you can create a copy of a worksheet or a workbook.

Note Note

You cannot refresh the data in a copy of a worksheet or a workbook by importing data from a database.

End of the note.

Procedure

  1. Click Start of the navigation path Data Matrix Next navigation step Snapshot End of the navigation path and then Workbook or Worksheet.

    A dialog box opens

  2. Enter the name of the workbook for which you want to create a snapshot or leave the field empty if you want to create the snapshot in a new workbook.

  3. Click OK.

Result

An identical copy of the workbook or worksheet is created in the specified workbook.

Note Note

This copy cannot be connected to a database.

End of the note.