Sharing Excel Reports with People without a Dynamic Planning License Using Snapshots

Companies often need to produce reports electronically that can be accessed by individuals without a Dynamic Planning license. This capability is provided in Excel Reports with Snapshots. The Snapshot format removes all Spotlight formulas from the report and saves all the data values as regular numbers, and dimension members as regular text, in Excel. There is no option to refresh the snapshot report because it is now static, and it is saved in a separate workbook from your Excel Report.

How to Create a Snapshot Report?

1. Open an Excel Report, click the More menu and select More > Snapshot.
   
   Note:

   Ensure that the data is refreshed and correctly reflects what you want to save.
2. Give the new snapshot report a file name because it will be saved separately.
   

After saving, the snapshot report will be on your screen so you can fine-tune it before sharing it.