# Toolbar button that will allow you to turn on and off the Velixo formulas **URL:** \ **Category:** Ideas & Feature Requests\ **Tags:** Sage-Intacct\ **Created:** [September 23, 2024, 7:48pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75 "2024-09-23T19:48:17Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Patrick\_Young](https://community.velixo.com/letter_avatar_proxy/v4/letter/p/7cd45c/32.png) [@Patrick\_Young](https://community.velixo.com/u/Patrick_Young)\ **Post date:** [September 23, 2024, 7:48pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/1 "2024-09-23T19:48:17Z")
Toolbar button that will allow you to turn on and off the Velixo formulas _This idea had 1 vote on the previous Velixo community._ ---
**Author:** ![Markens\_Juste](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@Markens\_Juste](https://community.velixo.com/u/Markens_Juste)\ **Post date:** [September 23, 2024, 8:06pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/2 "2024-09-23T20:06:52Z")
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? ---
**Author:** ![Patrick\_Young](https://community.velixo.com/letter_avatar_proxy/v4/letter/p/7cd45c/32.png) [@Patrick\_Young](https://community.velixo.com/u/Patrick_Young)\ **Post date:** [September 23, 2024, 8:17pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/3 "2024-09-23T20:17:54Z")
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. ---
**Author:** ![Markens\_Juste](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@Markens\_Juste](https://community.velixo.com/u/Markens_Juste)\ **Post date:** [September 23, 2024, 10:07pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/4 "2024-09-23T22:07:23Z")
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. ---
**Author:** ![Damien](https://community.velixo.com/user_avatar/community.velixo.com/damien/32/196_2.png) [@Damien](https://community.velixo.com/u/Damien)\ **Post date:** [September 25, 2024, 3:47am UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/5 "2024-09-25T03:47:23Z")
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** ![](https://community.velixo.com/uploads/default/original/1X/a14b002a75fb18854eb5bdc3bb6b3a28e7b5e128.png) Please let us know how you go with this. ---
**Author:** ![Patrick\_Young](https://community.velixo.com/letter_avatar_proxy/v4/letter/p/7cd45c/32.png) [@Patrick\_Young](https://community.velixo.com/u/Patrick_Young)\ **Post date:** [September 25, 2024, 12:43pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/6 "2024-09-25T12:43:54Z")
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. ---
**Author:** ![Damien](https://community.velixo.com/user_avatar/community.velixo.com/damien/32/196_2.png) [@Damien](https://community.velixo.com/u/Damien)\ **Post date:** [September 26, 2024, 12:19am UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/7 "2024-09-26T00:19:24Z")
Thanks Patrick. Then I think this idea sits on the Velixo side and could be possible. Thanks! Will definitely consider. ---
**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\ **Post date:** [February 14, 2025, 7:16pm UTC](https://community.velixo.com/t/toolbar-button-that-will-allow-you-to-turn-on-and-off-the-velixo-formulas/75/8 "2025-02-14T19:16:04Z")
Hi Patrick, This has been delivered. You can find information on the feature here: [https://help.velixo.com/support/solutions/articles/153000228196-freeze-unfreeze](https://help.velixo.com/support/solutions/articles/153000228196-freeze-unfreeze) Let us know if that meets your expectations!