Operis Analysis Kit
  • Applications
    • Spreadsheet Modelling
    • Spreadsheet Review
  • Features
    • Mapping a Model
    • Comparing Model Versions
    • Summarizing a Model
    • Using Named Ranges
    • Review Issues
    • Formula Explorer
      • Trace Dependents
      • Trace Precedents
    • Compliance with Best Practices
    • Excel Utilities
    • Excel Shortcuts on OAK
  • Pricing
  • Support
    • FAQ
    • Documentation
  • Blog
  • About OAK
  • Get in touch
Operis Analysis Kit
  • Applications
    • Spreadsheet Modelling
    • Spreadsheet Review
  • Features
    • Mapping a Model
    • Comparing Model Versions
    • Summarizing a Model
    • Using Named Ranges
    • Review Issues
    • Formula Explorer
      • Trace Dependents
      • Trace Precedents
    • Compliance with Best Practices
    • Excel Utilities
    • Excel Shortcuts on OAK
  • Pricing
  • Support
    • FAQ
    • Documentation
  • Blog
  • About OAK
  • Get in touch

Try OAK!     Buy Now!

Blog

OAK 5.3.005 released 17 Dec 2021

Share now

The latest version of OAK, version 5.3.005, released on the 17th of December 2021, is another major update to version 5.

Following our commitment to make OAK fully compatible with the new Excel Dynamic Array formulas, we are pleased to announce that today’s release is now able to recognize these new type of formulas across the entire spectrum of the OAK tools.

From the Formula Walker to the Optimize, the Reconstruct, the Prune and to all ‘Names’ associated tools, dynamic arrays are now identified and OAK will offer different options to the user. The user can choose to apply the tool to a spilling formula, to the corresponding parent formula or cancel the operation.

Our proprietary Parser is now capable of handling the new implicit intersection operator @ as well as the # suffix.

We have also removed the ‘Aggressive’ option from the Optimize, inherited from the previous version 4 , after feedback from our users.

Improvements on the Summary report, Risk analysis, were made for dealing with the @ and # operators.

We have also implemented the FIPS compliant encryption compatibility.

OAK is now using the .NET Framework version 4.8

There is a detailed version history of OAK in the online documentation.


Share now

Categories

  • Discover OAK
  • Modelling Insights
  • OAK Releases

Archive

Companies who decipher complex spreadsheets with OAK

ofgem-logo
Barclays_logo
BDO logo
CIBC-Logo
engie-energy-and-services-logo
hochtief logo
HSBC
Investec Bank logo
national audit office logo
Sonnedix logo

Pricing

Reduce the time and cost associated with interpreting a spreadsheet model using OAK. See what’s included in the price.

Blog

Discover how OAK helps solve a myriad of Excel issues on our blog.

Support

We’re here to help. Get answers to questions about installation, licensing and new releases.

OAK review

Everything you need to build, analyze and audit a spreadsheet. And make better decisions

Try OAK for free
Made for
Made for Microsoft
Made for Microsoft Excel

Start your 30 day Free Trial

  • This field is for validation purposes and should be left unchanged.

Privacy Policy
OAK
  • Features
  • Pricing
  • About OAK
  • Support
Legal
  • Privacy Notice
  • Cookie Policy
  • Legal disclaimers
  • Licence Agreement
OAK Applications
  • Spreadsheet Modelling
  • Spreadsheet Review
Financial Modelling Training
  • Financial Modelling for Solar Energy Projects
  • Financial Modelling for US P3 Projects
  • Financial Model Assessment and Review
  • Spreadsheet Modelling for Public Sector
  • Aligning Contracts and Financial Models for Lawyers
  • Excel VBA for Project Finance Models
Contact us
  • 110 Cannon Street
    London
    EC4N 6EU
  • +44 (0)20 7562 0400
  • [javascript protected email address]
Winners of the 2020 Financial Modelling Innovation Awards

©2026 Operis Analysis Kit. All Rights Reserved.

Powered by FL1 Digital