Toolbar button that will allow you to turn on and off the Velixo formulas
This idea had 1 vote on the previous Velixo community.
Hi Patrick,
Thank you for sharing this suggestion feature with Velixo.
May I know the reason you would like us to implement this idea, please?
Sometimes workbooks with many (or too many) formulas will want to refresh while working in them and it takes a while to update.
I was only thinking about toggle button to turn on and off.
Hi Patrick, thank you for the reply.
The refresh while working on a file is something related to how Microsoft Excel behave in the back end. It is something we are aware of and it is not related to Velixo. Microsoft Excel will try to look for any changes in any cells with formulas to make sure the data is correct. It will happen randomly. It is a concern that Velixo have share with Microsoft developer.
Good day Patrick
Thanks for your idea!
As Markens mentioned, this is a typical Excel behavior. Velixo leverages the standard Automatic recalculation option of Excel, and we would use our local cache whenever possible.
In scenarios where you need this sped up and it’s okay not to get live reevaluations of formulas, you could try changing the Calculation option to Manual: Formulas > Calculation Options > Manual
Please let us know how you go with this.
Thanks Damien. My thought process was for the Velixo formulas to only not calculate/refresh as they are the majority of the formulas/functions when dealing with a larger workbook with multiple tabs.
Hopefully, Microsoft can figure something out.
Thanks Patrick. Then I think this idea sits on the Velixo side and could be possible. Thanks! Will definitely consider.
Hi Patrick,
This has been delivered. You can find information on the feature here: https://help.velixo.com/support/solutions/articles/153000228196-freeze-unfreeze
Let us know if that meets your expectations!