Copy Workbook Without Formulas (Classic)
Created by Damien Zwillinger, Modified on Tue, 05 Sep 2023 at 12:27 AM by Damien Zwillinger
Applies to:
- Velixo Classic
- Acumatica, MYOB, Cegid
Overview
This feature is used to save a copy of the currently open workbook with all Velixo function calls removed from that new workbook.
This feature allows a workbook 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.
Example
Here we have a simple Velixo report. Notice that the workbook includes both Velixo functions...

... as well as Excel calculations:

By selecting Copy Workbook Without Formulas from the Velixo ribbon...

Or Without Velixo Formulas Only from the Velixo NX ribbon:

... we can save the workbook under a new name. That workbook still has all the Excel functions and calculations...

... but all the Velixo functions have been replaced with their respective values from the database:

This new workbook can now be sent to non-Velixo users who may want to make changes and see how the values recalculate.
Velixo Classic v5.0 and higher supports including protected sheets in your workbook (you will be prompted for the password when you select this feature) |
Removing ALL functions & formulas
If you wish to remove all of the Excel functions and formulas, as well as the Velixo functions and formula... use the pulldown arrow on the Copy Workbook Without Formulas button and...
In Velixo Classic, select to remove all formulas:

In Velixo NX, select Without All Formulas:

Copying Workbooks with AutoFilters Enabled
When using Excel's AutoFilter feature:

The Copy Workbook without Formulas 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 will remove the AutoFilters entirely, so as to avoid errors in your resulting file.
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