Many users experience the issue where Excel’s calculation mode changes without warning and without them realizing it. That’s pretty bad, right!<
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 also pretty bad, right!
I’ve been caught out by this several times in the past, and I’m guessing that since you’re reading this, you have been too. To help alleviate some of this pain, I created the Calc Buddy Add-in. Hopefully, you won’t be caught out by this ever again.
If you want to find out more about what causes Excel to work in this way, check out this post.
Here is what users are saying:
“Your calc buddy is a great tool! Thank you so much. We definitely need this add in across our whole team.” – R. Swann
“I wish this add in was included with Excel.” – J. Welfare
Introducing the Calc Buddy Add-in
Calc Buddy allows you to select your preferred calculation mode. Then each time a workbook is created, opened or saved, the add-in will check to ensure the calculation mode it is still set the way you want.
The following warning will appear when opening or creating workbooks:
The following warning will appear when saving a workbook:
Calc Buddy will work for all 3 calculation modes:
- Automatic except tables
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 the Calculation group 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. 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 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 distributed with 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 were 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 and later for Windows., and Excel 2016 and later for Mac.
On how many devices can I install Calc Buddy?
Each license is on a per-user basis for an unlimited number of devices. Feel free to 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. 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.