Recently, I wrote a post about what causes Excel’s calculation mode to change. Many users experience the issue where it changes without them realizing it. Due to the way Excel handles the calculation mode, the problem can easily be transferred to other workbooks, which can result in users issuing error-filled reports and quoting incorrect numbers. That’s pretty bad, right!
To help alleviate some of this pain, I’ve created the Calc Buddy Add-in. Hopefully you won’t be caught out by manual calculation mode again.
Introducing the Calc Buddy Add-in
Calc Buddy allows you to select your preferred calculation mode, then checks the calculation mode each time a workbook is created, opened or saved. If it is different to your preference, a warning message is displayed.
Warning when opening or creating workbooks:
Warning when saving a workbook:
It will work for all 3 calculation modes, so if you always work in manual mode or automatic except tables mode, you can select to be notified for that setting instead.
Not sure if Calc Buddy is for you? Here is what one reader said:
Your calc buddy is a great tool! Thank you so much. We definitely need this add in across our whole team as this issue has impacted numerous people.
Setting up the Calc Buddy Add-in
Calc Buddy does not take up a lot of space in the ribbon. It will only add a small button to the empty slot in Calculation section of the Formulas tab.
Click the Calc Buddy icon and a new window will open
Use the tick box to enable or disable the warnings. If enabled, select your preferred calculation mode from the drop-down box, then click Save + Close.
That’s it. Simple.
Download the Calc Buddy Add-in
Now you know how it works, it’s time to download the Add-in.
The Calc Buddy Add-in is available for newsletter subscribers to download for free.
Existing newsletter subscribers can enter their name and e-mail address into the form below to download instantly. Or, if you are not a subscriber, you can enter your name and e-mail address below to become one.
Whilst I try to create safe and reliable templates and add-ins, I can (and often do) make mistakes. Please backup copies of your files before opening this template or running any VBA code. If you do find any bugs or errors, please let me know using my contact page.
By using any templates, add-ins, downloads or information from the site, you agree that I will not be held liable for any type of damages, and use is entirely at your own risk.
Install the Calc Buddy Add-in
The Add-in is easy to install, just follow the pdf instructions which come within the download, or follow the instructions in this post.
The Future of Calc Buddy
Obviously, it would be better if this type functionality were built into Excel already, or even better if the calculation mode was applied at the workbook level. In the future, I hope this feature is added, and Calc Buddy will no longer be required. Until then, I hope you find it useful.
Still Got Questions?
Which versions of Excel does Calc Buddy work on?
Calc Buddy should work on Excel 2007 – 2016 for Windows and Excel 2016 for Mac.
How many devices can I install Calc Buddy onto?
Each license is on a per-user basis for an unlimited number of devices. You can use Calc Buddy at home, at work and anywhere else you like.
Can I share Calc Buddy with my friends and work colleagues?
Just send them a link to this page and they can sign-up to get their own copy of the Calc Buddy add-in. If you want a site license for your entire team/business, please contact me to discuss.
Where can I get help if I need it?
The help pages can be accessed from within the Calc Buddy Add-in itself, but can also be found here.
What are the terms of the License?
Find the End User License Agreement here.