Overview
Resolution
All Collections
Advanced Features
Alternative Algorithm when Removing All Formulas
Alternative Algorithm when Removing All Formulas
to avoid slow processing with certain configurations of Excel
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

Overview

Velixo Classic offers multiple options for removing functions and formulas from your report...

Both from the Velixo ribbon:

and using the Velixo Distribution List feature:

copy_no_formulas2.png

Issue:

Some configurations of Excel experience issues with the method that is used to accomplish this.

Resolution

For those users who experience very slow file creation, Velixo Report offers an the Option of using an alternative method for removing the functions and formulas from the report:

options_faster.png

Velixo recommends that most users leave this option turned OFF.

Velixo provides this option for those users experiencing specific issues, and it should should ONLY be used if you experience performance issues when removing all formulas (this option does not affect removing "Velixo formulas only").

This alternative technique can create issues with certain fonts (we have seen specific issues with Wingdings) or when a report has a filter applied to a table.

Did this answer your question?