Breadcrumbs

Freeze / Unfreeze

Overview

The Velixo NX ribbon includes buttons for Freeze and Unfreeze:

Velixo NX ribbon showing the Freeze and Unfreeze buttons in the Tools section


When a worksheet (or entire workbook) is frozen, cells with present Velixo functions will be temporarily converted to the values returned by these functions. The user can use the Unfreeze feature to re-enable the Velixo functions.

The Velixo NX Freeze feature allows us to temporarily disable the Velixo functions. The cases where this functionality is useful include:

  • Working offline (on a flight, for instance, where Velixo cannot reach the ERP)

  • Collaborating with colleagues who do not have a Velixo license without the necessity to remove all Velixo functions from the worksheet

    • If you don't need to Unfreeze the worksheet later, consider using the Snapshot functionality

  • Freezing selected worksheets in a workbook to speed up updates


A Freeze can be applied to an entire workbook or to one or more individual worksheets.

Velixo NX Freeze button dropdown showing options to freeze the current sheet or entire workbook

Example

This sample Trial Balance worksheet contains Velixo functions that return data from an ERP instance, for instance:

  • The account name Petty Cash in C14 is returned by the ACCOUNTNAME function

    Trial Balance worksheet with ACCOUNTNAME function in cell C14 returning the account name Petty Cash


  • The Beginning Balance value in D15 is returned by a combination of an Excel function and Velixo functions

    Trial Balance worksheet showing Beginning Balance value in D15 computed by a combination of Excel and Velixo functions



If you want to share this Trial Balance worksheet with someone who doesn't have Velixo NX, you can Freeze the worksheet by clicking Freeze → Current Sheet in the Tools section in the Velixo NX menu.

Velixo NX ribbon showing the Freeze dropdown with Current Sheet option highlighted


This will temporarily disable all Velixo functions in the worksheet and substitute them with the values they returned when last calculated.

  • The values in the spill range returned by the ACCOUNTNAME function are now stored as strings in the formula, with the function name and its parameters at the end

    Frozen worksheet cell showing ACCOUNTNAME result stored as a string value with original function parameters appended in the formula


    Frozen Trial Balance worksheet with all Velixo function cells converted to static string values for offline sharing


  • The Beginning Balance values in the spill range returned by the combination of Excel an Velixo functions are now stored as strings in the formula, with the original functions and parameters at the end

    Frozen worksheet showing Beginning Balance formula stored as a string with original Velixo function parameters appended


Frozen Trial Balance worksheet overview with multiple cells displaying static values after Velixo functions were frozen


Now, the worksheet can be edited offline or without a Velixo license.

You can then Unfreeze the worksheet to bring back Velixo functions.

Velixo NX ribbon showing the Unfreeze button in the Tools section to restore Velixo functions in the worksheet