Snapshot
Created by Harry Lewis, Modified on Mon, 26 Aug at 7:27 PM by Damien Zwillinger
Applies to:
- Velixo NX
Note: For Velixo Classic, see: Copy Workbook Without Formulas (Classic)
Overview
This feature (formerly known as Copy Workbook Without Formulas) is used to save a copy of the currently open worksheet or workbook with all Velixo function calls removed from that new workbook. This feature allows a workbook/worksheet to be distributed to non-Velixo users who may want to make adjustments and recalculate that workbook. You also have the option to remove all Excel functions as well.
Examples
Removing Velixo functions and formulas
Here we have a simple Velixo report. Notice that the workbook includes both Velixo functions...
![copy01.png](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000077156/original/0kCy7cgwgagHVhR1aDx2LDUpxted6n74aA.png?1692943875)
... as well as Excel calculations:
![copy02.png](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000077155/original/3BahXHTbM6UJrk8OKDSOlT2zZqn8Mb9YcA.png?1692943875)
By selecting Snapshot from the Velixo NX ribbon:
... the Create a Snapshot side panel will open:
Here, we can select if we want to snapshot:
- the entire workbook
- only the current sheet (and if we want that sheet to be placed in the current workbook or a new workbook)
and
- All formulas
- Only the Velixo formulas
Assuming we select to Snapshot the entire workbook and remove only the Velixo formulas:
we can save the resulting workbook under a new name. That workbook still contains all the original Excel functions and calculations...
![copy02.png](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000077149/original/jhkTug1QualAZrFH3Kr0ksJF65lIdq4Uhg.png?1692943875)
... but all the Velixo functions have been replaced with their respective values from the database:
![copy04.png](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000077154/original/DY9WeoDU9Fu3JjX8OwWYfit1MwxuqfF2hQ.png?1692943875)
This new workbook can now be sent to non-Velixo users who may want to make changes and see how the values recalculate.
Removing ALL functions & formulas
If you wish to remove all of the Excel functions and formulas, as well as the Velixo functions and formula...
In Velixo NX, select Snapshot:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153024363798/original/K_ZEiMQnXAlW5sMv-auxZnYax-qLQoSvdg.png?1724707650)
and select to remove All formulas:
Snapshot Workbooks with AutoFilters Enabled
When using Excel's AutoFilter feature:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000077152/original/_Jp9fpM8-ffCzVGAUGTCDibOuggzNDwkdw.png?1692943875)
The Snapshot feature will make every effort to maintain those settings.
However, some AutoFilter settings cannot be preserved during the copy process. When that is the case, Velixo NX will remove the AutoFilters entirely, so as to avoid errors in your resulting file.
Important information regarding protected workbooks If the workbook is protected WITHOUT A PASSWORD, the Snapshot process should create a workbook that is NOT protected. If the workbook is protected WITH A PASSWORD, the process will stop, and the following message will be displayed:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article