DoneEx

  • Home
  • News
  • XCell Compiler
    • Features
    • Compile Excel Workbook to EXE
    • Protect Excel Formulas
    • Protect Excel VBA code
    • How to Create a Trial/Demo Protected Workbook
    • How to use registration key tool
    • Bulk Registration Key Generator
    • Protect workbook with dongle
    • How to export/import changed data
    • How to hide Excel on start
    • How to select target Excel bitness
  • VBA Compiler
  • Installer Maker
    • Installer Maker Options Overview
    • Create Installer for Excel Workbook or Excel Add-in
  • Frequent Q&A
    • Technical
    • Install / UnInstall
    • Updates
    • Trial Version of XCell Compiler
    • Buying XCell Compiler
    • Customer Service
    • Misc FAQ
  • Download
  • Buy
  • Testimonials
  • Contact Us

Protect Excel formulas from being copied by converting them into binary code

Microsoft Excel provides an easy and convenient way to trace, research, and reconstruct the worksheet cell formulas and algorithms through the use of their ‘Formula Auditing’ tools. You may trace all dependencies and precedences of the formulas in a workbook using the corresponding tools in “Formula Auditing”.
You may figure out how a formula gets its value with step-by-step formula calculation tracing. You may find this tool by going to the “Main menu” and selecting “Formulas”, then the “Formula Auditing” group and selecting the “Evaluating Formula” item.

But what if the workbook author wants to hide spreadsheet formulas from prying eyes?

There may be different reasons as to why an author wants to hide and lock the formulas in spreadsheet.

    1. Prevent accidental deletion or changes in cell formulas.
    2. Keep proprietary cell formulas and algorithms secret.

In case of  item 1  –  Microsoft Excel provides easy to use tools to hide and lock formulas in cells.

How to hide and lock formulas in Excel workbook

Formula protection tools provided by Microsoft Excel are good enough to achieve the first goal of “preventing accidental deletion or changes formulas” but these tools absolutely are not fit for the second goal of “keeping the proprietary algorithms a secret” because they only hide the equations from showing in cells and formula bar, but all these equations remain reachable by many other ways.

In contrast to Excel’s approach to hiding and locking formulas, the DoneEx XCell Compiler provides a revolutionary method to protect cell formulas in your workbook.
XCell Compiler doesn’t just hide equations from worksheet cells – it does so much more! The product compiles all formulas into a binary format and moves all equations into an executable (EXE) file as pure algorithms. After this process, not a single formula is left in the spreadsheet’s cells. This means that nobody will be able to see, trace or reconstruct the protected formulas.

 

Protect Excel formulas with DoneEx XCell Compiler

The DoneEx XCell Compiler provides the strongest Excel formula protection approach you could possibly have! The best part is that every version of DoneEx XCell Compiler provides the absolute best Excel formulas protection and does so by default with every compilation you conduct! The XCell compiler secures all workbook  formulas by moving them from xls into binary code and removes them from the cells of xls (xlsx, xlsm, xlsb) file.

To reach this goal, DoneEx engineers developed our own calculation engine which works during the compiled formula calculation process by substituting the original Excel’s calculation in the protected workbook, while the Excel itself is used for formatting and reflection of calculation results.

 

This is the only way to really protect Excel formulas!

Even encoding your workbook with a strong encryption algorithm is not really all that secure, because then you may need to provide the decryption key for a user and once you do that your data is decrypted and potentially available for anybody.

  • To check if there are any available formulas in any compiled EXE you can switch Excel into “Formula Auditing Mode”.

To do this go to “Main Excel menu” >> “Tools” >> “Formula Auditing” >> “Formula Auditing Mode”

  • To check that formulas are not available from VBA code you can use the following equation in VBA:

Sheets(“sheet name from your workbook”).Range(“address of the cell with the formula”).formula

Secure formula protection is available for any and all of the DoneEx XCell Compiler licenses . To protect your formulas, you just need to compile your xls file with DoneEx XCell Compiler.

 

How to Hide and Lock Formulas in Microsoft Excel

The original Microsoft Excel formula protection uses the “Lock and Hide Excel workbook formula protection” approach, which is weak and inefficient.
The Original Microsoft Excel formula protection is activated as such:

    1. Select all of the cells that contain the formulas you wish to protect, much like in the screenshot shown below.

Excel formula protection.Cells containing formulas highlighted.

 

    1. While those Cells are selected, go to the “Home” tab on the Excel toolbar, click on the “Format” drop down menu and then click on the “Format Cells” button.

Excel formula hide and lock."Format Cells" item through Excel Ribbon menu to protect formula.

 

Or, while the Cells with the formulas you wish to protect are selected, you can right mouse button click and then click on the “Format Cells” button.Excel workbook formula protection.Right mouse button click menu "Format Cells" item to protect formula.

 

    1. The previous steps should have led to the “Format Cells” menu coming up on your screen. Here you can turn on the “Hidden” check box under the “Protection” tab. After you have done that, you can press “OK” to confirm your actions so far.

Excel formula protection."Format Cells" menu with "Protection" tab, "Hidden" option on, and ok marked and highlighted.

 

  1. Go to the “Review” tab on the Excel toolbar and click on the “Protect Sheet” button.

 

This should bring up the “Protect Sheet” menu, which allows you to set a password for your worksheet. After setting a password by typing it in the field labeled as “Password to protect worksheet” (which you can even leave blank) and pressing “OK”, the equations (which you have previously selected in step 1) that are located on your worksheet should be protected with the original Microsoft worksheet formula protection.Microsoft Excel "Protect Sheet" menu with "OK" button marked and highlighted.

 

This process also prevents the equations in the cells from being edited. Now whenever any user attempts to edit any cell you have protected in this manner the alert window that is displayed in this screenshot should come up:"Your Excel workbook complation done successfully" window

 

The original Excel formula protection is weak and inefficient.

Any method that just involves hiding Excel formulas does not provide sufficient formula protection, since any hidden formulas of an workbook can easily be made visible or be fetched through some other means.

The main goal of spreadsheet copy protection is to remove formulas from cells to make them unavailable to anyone. If the formulas are not secured then anyone who has permission to open your workbook (even if it was protected with a password, license key and/or a hardware dongle) may copy all of the data and formulas (manually or by using some software) into an unprotected workbook and use your intellectual property without any restrictions.

 

See also: How to compile your workbook.

 

VBA Compiler available

  VbaCompiler for Excel
VBA to DLL

  • Excel Compiler
    • Features
    • Protect Excel formulas
    • Compile workbook to EXE file
    • Compile for Excel 32 and 64 bit
    • Protect Excel VBA code
    • Activation key for workbook
    • Create trial / demo workbook
    • Hide Excel on start
    • Export/import changed data
    • Protect with dongle, USB stick
    • Frequent Q&A
    • Download Excel Compiler
    • Privacy Policy
    • EULA
  • VbaCompiler for Excel
    • Bulk Registration Key Generator
Copyright 2005-2023 © DoneEx LLC. All Rights Reserved