Show TOC

Procedure documentationCreating a Snapshot of a Worksheet or Workbook Locate this document in the navigation structure

 

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   Data Matrix   Snapshot   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.